false date conversion - Githubissues

DiegoZoracKy / convert-excel-to-json

Convert Excel to JSON, mapping sheet columns to object keys.

MIT License

290 stars 91 forks source link

Open myruldeen opened 5 years ago

DiegoZoracKy commented 5 years ago

more info, please?

myruldeen commented 5 years ago

Date from excel sheet with format eg. 1/1/2019 after convert it become 2018-12-31T15:59:14.000Z

myruldeen commented 5 years ago

then check for the {cellDates: true} according to xlsx/sheetjs documentation

DiegoZoracKy commented 5 years ago

There is an open issue on SheetJS regarding that case: https://github.com/SheetJS/js-xlsx/issues/1470

myruldeen commented 5 years ago

Any updates regarding the date issue? Another suggestion is using moment(date).add(1, 'days').toDate()

lalote commented 4 years ago

in my case i have 2020-04-02 19:00:00 and get 2020-04-01T18:59:59.999Z

myruldeen commented 4 years ago

it seems the xlsx library have a problem dealing with date on excel. I just hardcoded it in my own project by making some wrapper :(

myruldeen commented 4 years ago