SheetJS js-xlsx
npm i xlsx -S
readerData(rawFile) { this.loading = true return new Promise((resolve, reject) => { const reader = new FileReader() reader.onload = e => { const data = e.target.result const workbook = XLSX.read(data, { type: 'array', cellDates: true // raw: true }) console.log('workbook===', workbook.Sheets) const worksheet = workbook.Sheets[workbook.SheetNames[0]] const header = this.getHeaderRow(worksheet) const results = XLSX.utils.sheet_to_json(worksheet) this.generateData({ header, results }) this.loading = false resolve() } reader.readAsArrayBuffer(rawFile) }) },
cellDates: true
Sun Jan 03 2021 00:00:00 GMT+0800 (中国标准时间)
27.02.2021
const workbook = XLSX.read(data, { type: 'array', raw: true })