Date deviation problem #3149

New Issue

Kerwin · 2024-07-11T02:34:47Z

Kerwin commented

2024-07-11 02:34:47 +00:00

When sheetJS reads Excel, using this method,

XLSX.read(data, {type: 'binary', cellDates: true});

it is found that the converted date is inaccurate

When sheetJS reads Excel, using this method, XLSX.read(data, {type: 'binary', cellDates: true}); it is found that the converted date is inaccurate

Screenshot 2024-07-11 103354.png

16 KiB

sheetjs commented

2024-07-11 05:35:55 +00:00

As explained in https://docs.sheetjs.com/docs/csf/features/dates, date and time support was overhauled in version 0.20.0. Please log the version number (e.g. XLSX.version) and confirm it is at least 0.20.0.

If it does affect newer releases, please share a sample file so we can take a closer look.

As explained in https://docs.sheetjs.com/docs/csf/features/dates, date and time support was overhauled in version `0.20.0`. Please log the version number (e.g. `XLSX.version`) and confirm it is at least `0.20.0`. If it does affect newer releases, please share a sample file so we can take a closer look.

Sign in to join this conversation.