Date Time from excel coming as number

[Amol_Golhar]

Dear Team,

I have to read date and time from two diffrent cells, when i am using Read Cell Workbook activity, value coming as numbers.

Thanks,
Amol Golhar

[Davuluri_Manikumar]

Hi @Amol_Golhar ,

check any formulas were involved in the background of cells

[mkankatala (Mahesh Kankatala)]

Hi @Amol_Golhar

In Read range workbook activity properties check the preserve format option and try.

Check the below image for better understanding,

Hope it helps!!

[lrtetala (Lakshman Reddy)]

Hi @Amol_Golhar

Can you try below

DateTime.FromOADate(44622)

Cheers!!

[Amol_Golhar]

Dear Team,

@Manikumar, Cell format are date and time as shown in Snapshot.
@Mahesh, Preserver fromat has been enabled.
@Laxman, I have tried, DateTime.FromOADate, it is working but getting date and time value separately.

Thanks,
Amol Golhar