Not a legal OleAut date
Invalid business date entered in SAP
There seems to be no other way to fix this issue rather then removing the dates from SAP
31.12.0018 for instance is not a valid business date and therefore it is not recognized in Excel when the application tries to write data so there is no way to change the excel behavior.
As the date 31.12.0018 is not valid in Excel, it does not accept this data entry and therefore the error message appears and the run is cancelled for this records.
There are two ways we use in winshuttle to read and write to excel . First is ComExcel and other is Spreadsheet gear.
1. When we click on run now and run in background check box is unchecked, we use spreadsheet gear. So spreadsheet gear does not cause issue.
2 When we click on run now and run in background check box is checked, we use Comexcel . This will cause issue.
3.When we click on run later and we use Comexcel . This will also cause issue.