When using node-xlsx to parse excel files, the contents similar to 2015/3/23 are displayed as an integer of 52324 after reading. How can I correctly parse the date contents?
node-xlsxOnly data can be read, and the format cannot be recognized.
What you saw in excel inside
2015/3/23, should be set the cell format, essentially stored or a number, you can go to excel to see how the original data.
There are two solutions:
1. First process the excel data and make it into a string (copy it to a text editor and paste it back);
2. Format numbers into date strings according to excel formatting functions.
When the amount of data is small, mode 1 is quick, simple and rough.