Still a problem with date parsing

[svendeckers]

I've read issues similar to mine, but I haven't found a solution yet.
I made a CSV-file in a texteditor, VI, so no Excel-involvement here.
I entered a date in DD/MM/YYYY notation ("01/04/2018"), so this is the first of April.
Any way I try to read the date, I always get the 4th of January returned:

let workbook = XLSX.readFile("./dateTest.csv", {cellDates:true,dateNF:'dd/mm/yyyy'});
let worksheet = workbook.Sheets[workbook.SheetNames[0]];
let cell = worksheet["A2"];
console.log(cell.w);
Results in "04/01/2018".

dateTest.csv:
DATE;
01/04/2018;

It seems the value is interpreted in the local settings, regardless of the dateNF.
I cannot ask my clients to change their settings.
Am I missing something or are we waiting for the locale option to be passed with readFile?

[sangeethaharidass]

Use xlsx.read function procedure to read a file.

[svendeckers]

I'm glad you took the effort, but unfortunately to no avail.

When I read the file using fs.readFile and I print the contents, I get this:
01/04/2018
Then I do:
let workbook = XLSX.read(contents, {cellDates:true,dateNF:'dd/mm/yyyy'});
let worksheet = workbook.Sheets[workbook.SheetNames[0]];
let jsonData = XLSX.utils.sheet_to_json(worksheet, {header: headers, defval: ''});
and print the jsonData and I get:
04/01/2018

[ArturPrzybysz]

Any progress on the topic?

[svendeckers]

Not from my side

[bean5]

I am seeing DateTimes in CSV treated differently than those in XLSX files. See also: SheetJS/SheetJS.github.io#14

[louis-nguyen-97]

Any update on this issue? I faced the same problem.