When using node-xlsx to parse excel files, contents similar to 2015/3/23 are displayed as an integer of 52324 after reading

  node.js, question

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 inside2015/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.