search

wnabil / ngx-export-as

Angular 2+ / Ionic 2+ HTML/table element to export it as JSON, XML, PNG, CSV, TXT, MS-Word, Ms-Excel, PDF
MIT License
68 stars 40 forks source link

Date format is changed from yyyy-MM-dd to MM-dd-yyyy #59

Closed shubham708 closed 4 years ago

shubham708 commented 4 years ago

Date in my HTML table is 2020-01-21. After export as .xlsx, it is changed to 1/21/2020. Why?

How to keep it as it is?

wnabil commented 4 years ago

Check the option called dateNF https://github.com/SheetJS/sheetjs#html-table-input