search

mgcrea / node-xlsx

NodeJS excel file parser & builder
Other
2.96k stars 274 forks source link

When parsing a date, it returns the excel-date format #180

Closed jeer00 closed 1 year ago

jeer00 commented 2 years ago

When parsing a date, it seems to return the excel-date-format. Although the .xlsx hasnt specified that date-format. Example: '18/03/2017' becomes: 42812

jahon commented 2 years ago

please setting the options;

`const options = { type: "buffer", cellDates: true, cellHTML: false, dateNF: "yyyy-mm-dd hh:mm:ss", cellNF: true };

// Parse a file const workSheetsFromFile = xlsx.parse(fileName, options);`

stale[bot] commented 1 year ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.