Read a date from Excel but the result turns to be numbers

hi

I tried to use the workbook read range acitvity to load an excel, but the dates in the excel turn into number in DataTable:

how it looks like in Excel:

how it looks like in UI Datatable
2

attached my code
_Test2.xaml (10.3 KB)

please~~ share you suggestion with me~

Hi @Cynthia ,

Can you please attach the xl sheet ?

Regards
Balamurugan

please check the formate of the cell in excel, if it is generic then it write as numbers,
try after changing the cell formate to date

UI Path is pulling the OA date from excel. There is a way to convert this back to datetime format. Something like DateTime.FromOADate

3 Likes

thanks @KEntwistle

it’s Datetime.FromOADate(Convert.ToDouble(row(β€œβ€)))

3 Likes