Closed
Description
I want to export date/time values to JSON formatted as ISO 8601 values
My current script:
const XLSX = require('xlsx');
...
const file = XLSX.readFile(path,{cellDates:true, cellNF:false});
for (sheet in file.Sheets){
//remove prerendered values, otherwise dateNF is ignored
for (cellref in sheet){
const c = sheet[cellref];
if(c.t==="d"){
delete c.w;
delete c.z;
}
}
const format = "YYYY-MM-DD hh:mm:ss";
//const format = "YYYY-MM-DDThh:mm:ss"; throws exception as it doesn't recognize T
const data = XLSX.utils.sheet_to_json(sheet, {header: 1, dateNF:format});
.....
}The cells itself already contain the correct datetime inside the v(alue) attribute.
I suggest an option like
XLSX.utils.sheet_to_json(sheet, {header: 1, ExportDatesAsISO:true});
Test data:
datum.xlsx
Metadata
Metadata
Assignees
Labels
No labels