We are receiving some excel files where the formatting of datetimes varies from file to file and this formatting needs to preserved.
But when trying to extract this data via either a ReadCell or a ReadRange activity the returned value is just the raw datetime string (in MM/dd/yyyy hh:mm:ss format)
This also happens when trying to access the cell value directly via workbook.ReadCell(Of String)(Range as string)
Is there any way to either
a: Force uipath or a vb.net method to access the displayed value rather than the stored value in excel
b: Read out the applied formatting so i can convert the datetime value myself to the same format in a tostring().
The excel file is from an external source and cannot be modified.
Thanks in advance