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

excel

#1

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~


#3

Hi @Cynthia ,

Can you please attach the xl sheet ?

Regards
Balamurugan


#4

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


#5

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


#6

thanks @KEntwistle

it’s Datetime.FromOADate(Convert.ToDouble(row("")))