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

[StarFighter (Hüseyin Sina Sungur)]

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 .

Kindly help me out this.

[Harshith_Adyanthaya]

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.

[Gokul_Jayakumar (Gokul Jai)]

@StarFighter

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

@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.

[StarFighter (Hüseyin Sina Sungur)]

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

[StarFighter (Hüseyin Sina Sungur)]

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

[saritha]

May I know solution for this how to achieve it

[hp321 (ap)]

Hi @saritha ,
Give a look at this thread:

How to convert every element in a data table into a string for use in a "Type into" activity

dt(1).ToString returns the 2nd row of the datatable if you want the 1st column of 2nd row, you need to do this: dt(1)(0).toString → this will give you the value of the 1st column of the 2nd row To loop over each and every element, do the following: use foreach row in datatable activity to loop each row inside, use a foreach activity to loop each column, where the target is dt.Columns, and typeArgument = DataColumn (see screenshot below) finally in the foreach, you can have your type activit…