Posted 25 November 2022, 1:59 am EST
Hi,
I am trying to parse an Excel file which is imported in our application using ExcelIO library.
excelIo.open(
file,
(json) => {})
Something like above. In that excel file we have dates(MM/dd/yyyy) as well for which when i found TYPE as integer in microsoft excel. When i tried to display that value , i was getting it as /OADate(…)/. How to resolve this? How to convert this to MM/dd/yyyy format?
Thanks