1 . yarn或npm 安装 xlsx
2. 在upload上传组件的beforeUpload钩子函数中拿到文件对象
3. let dataBinary = await readFile(file)
let workBook = XLSX.read(dataBinary, { type: 'binary', cellDates: true })
let workSheet = workBook.Sheets[workBook.SheetNames[0]]
const data = XLSX.utils.sheet_to_json(workSheet)
这里data可以拿到数组对象
4. export const readFile = (file) => {
return new Promise(resolve => {
let reader = new FileReader()
reader.readAsBinaryString(file)
reader.onload = ev => {
resolve(ev.target.result)
}
})
}