Date not preserved from CSV to XLSX

[LouisDelbosc]

trafficstars

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) ?

CSV

XLSX

import on google spreadsheet

[rcoundon]

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

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