Uipath read range, reading showing different values For Date

[hansen_Lobo]

Hello,

I have a read range activity, where the bot reads the excel sheet,

But when i see the values (Highlighted in yellow) its either 0 or 45xxx. Where as the excel sheet as the data:

formulas being using in excel to calculate those date values.

Bot Output :

Similarly in a other situation, highlighted in blue, only one row value data is shown correctly (The value is written, not calculated using formula), where as rest values are 45xxx

Is there i am doing anything wrong?
And i want the data in Date time format. for further processing

I should be using workbook activity, since there is no Excel in the system.

Update:
I see some formulas being using in excel to calculate those dates.

[Srini84 (Srinivas)]

Hi @hansen_Lobo

Check below link for your reference

Convert Number to Date Format || UiPath || RPA UseCase

Hope this may help you

Thanks,
Srini

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @hansen_Lobo ,
This cells are ‘Datetime format’ → read by read range workbook will have value as 45…
You can install Excel application then change to Excel scope then use read range
While reading range from excel make sure you enable preserve Format

If you can install Excel Application, you can use read workbook then convert them to ‘Date time’

You can use the following expression to convert an Excel date value (e.g., 45175) to a formatted date string:

DateTime.FromOADate(CDbl(your column)).ToString(“dd/MM/yyyy”)

regards,