Write Range Workbook: Unable to set cell value to 01/01/1753 00:00:00

Help Activities
, ,
1

Hi All,
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 .

image
image1142×656 199 KB

Kindly help me out this.

2

Hi @StarFighter,

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.

1 Like
3

@StarFighter Welcome to UiPath Community.
Try this
Convert the Values into strings then write in Excel. Make sure the Excel sheet ranges should in general or Text format.

5

Thanks for you answer, How can I convert my datatable to string then write it to Excell?

6

Thanks for you answer, How can I convert my datatable to string then write to Excell?

1 Like