vue+element 解析xlsx

安装

npm install xlsx --save

引用

import * as XLSX from 'xlsx/xlsx.mjs'

结合element

<el-upload
    action
    accept = ".xlsx, .xls"
    :auto-upload="false"
    :show-file-list="false"
    :http-request="uploadFile">
    <el-button type="primary">导入excel</el-button>
    </el-upload>

 async uploadFile(params) {
      const _file = params.file
      const fileReader = new FileReader()
      fileReader.onload = ev => {
        try {
          const data = ev.target.result
          console.log(data)
          const workbook = XLSX.read(data, {
            type: 'binary',
          })
          for (let sheet in workbook.Sheets) {
            //循环读取每个文件
            const sheetArray = XLSX.utils.sheet_to_json(workbook.Sheets[sheet])
            //若当前sheet没有数据，则continue
            if (sheetArray.length == 0) {
              continue
            }
            console.log('读取文件')
            //解析返回的json
            console.log(sheetArray)
            }
        } catch (e) {
          this.$message.warning('文件类型不正确！')
        }
      }
      fileReader.readAsBinaryString(_file)
    },