js reads excel time format conversion

Use xlsx.full.min.js to get the date data of excel: 37858;

The integer value obtained is the number of days from the date to January 1, 1900. At this time, a function needs to be written to convert:

/*** Excel import plug-in method: excel time formatting* @param {*} numb excel time format* @param {*} format conversion delimiter* @returns standard time format*/export function formatExcelDate(numb, format) {// daysconst time = new Date((numb - 1) * 24 * 3600000 + 1)console.log(time)time.setYear(time.getFullYear() - 70)const year = time.getFullYear() + ''const month = time.getMonth() + 1 + ''const date = time.getDate() + ''// Converted format symbolif (format && format.length === 1) {return new Date(year + format + month + format + date)}return (year + (month < 10 ? '0' + month : month) + (date < 10 ? '0' + date : date))}

Parameter: numb is the integer value converted by excel, format is the separator between the year, month and day.

Replace Chinese in excel sheet with English

/*** Excel import plug-in method: key Chinese to English* @param {*} results data to be converted* @param {*} maps Chinese-English mapping relationship of converted data* @param {*} times the excel time attribute name that needs to be formatted* @returns*/export function transformKeys(results, maps, times = []) {const newArr = []results.forEach((item) => {// Replace with a new object whose key is English and add it to the arrayconst _item = {}for (const key in item) {const enKey = maps[key]if (times.includes(enKey)) {// format excel time_item[enKey] = formatExcelDate(item[key], '-')} else {_item[enKey] = item[key]}}newArr.push(_item)})return newArr}