I have a cell that is read and operated by node-xlsx. One of the columns has a date format:
However, after reading, I found that the value of this column has become a string of floating-point data.
Ask the great god to instruct us how to convert the string of numbers into the time format of excel table.
Look at the following documents and find a solution. If you can read English without obstacles, look here.https://github.com/mgcrea/nod …
var date = new Date(1900, 0, dateVal - 1);
So the result of the calculation is