New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
sheet_to_json function changes original date format #2756
Comments
https://docs.sheetjs.com/docs/csf/features/dates#how-files-store-dates-and-times The file itself may be using the magical format If you want to reformat the dates, pass the option At some point we will offer a more general solution |
i find those problem to last time, so i just add option raw: false |
My problem is: XLSX.utils.sheet_to_json |
A user uploads an xlsx document, and one of the columns is a date, and it's displayed as "2022/7/21"
but when sheet_to_json read the xlsx, the data formats will change like this
How to resolve this problem
Thanks
xlsx: ^0.18.5
The text was updated successfully, but these errors were encountered: