I’m getting the following error using write range workbook."Write Range Workbook: Unable to set cell value to 01/01/1753 00:00:00 ". I have too many values including dates. And some of dates are like 01/01/1753 00:00:00 .
Kindly help me out this.
This is because excel uses the date system starting from January 1, 1900. All dates before that are invalid.
You can convert it to string ad update.
@StarFighter Welcome to UiPath Community.
Convert the Values into strings then write in Excel. Make sure the Excel sheet ranges should in general or Text format.
Thanks for you answer, How can I convert my datatable to string then write it to Excell?
Thanks for you answer, How can I convert my datatable to string then write to Excell?