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


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

attached my code
_Test2.xaml (10.3 KB)

please~~ share you suggestion with me~

Hi @Cynthia ,

Can you please attach the xl sheet ?


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

1 Like

thanks @KEntwistle

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