Skip to content
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

Date not preserved from CSV to XLSX #2740

Open
LouisDelbosc opened this issue Jul 13, 2022 · 1 comment
Open

Date not preserved from CSV to XLSX #2740

LouisDelbosc opened this issue Jul 13, 2022 · 1 comment

Comments

@LouisDelbosc
Copy link

LouisDelbosc commented Jul 13, 2022

I'm reading some csv data and try to convert it to XLSX. I have a datetime column and it seems the data is not preserved correctly between CSV and XLSX.

I joined some screenshot opened with numebrs and google spread sheet. It is a known issue ? If I use excel will the data be preserved (having a datetime and not a date or just a number) ? Or maybe I did miss an option ? ( I added cellDates: true on reading and writing) ?

Screenshot 2022-07-13 at 11 33 09

CSV

Screenshot 2022-07-13 at 11 33 20

XLSX

Screenshot 2022-07-13 at 11 34 51

import on google spreadsheet

@rcoundon
Copy link

I found similar and ended up (rightly or wrongly) using this function/library to do the conversion

import { getJsDateFromExcel } from 'excel-date-to-js

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants