In JavaScript, when we fetch a date field from an excel file, it shows some integer/floating point number.
To convert the number back to date, we can use the following:
- install excel-date-to-js package (npm i excel-date-to-js)
- Run this snippet:
const { getJsDateFromExcel } = require("excel-date-to-js")
getJsDateFromExcel(dateFieldFromExcelFile) e.g. getJsDateFromExcel(data[1][0])
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…