vue 导入excel

npm i xlsx -S

import { read, utils } from "xlsx"

<el-upload class="upload-demo"
   action="https://jsonplaceholder.typicode.com/posts/"
           accept='.xls,.xlsx'
           :on-success="handleChange"               
           :show-file-list='false'   
           :file-list="fileList">
  <el-button size="small"
             type="primary">导入EXCEL</el-button>
</el-upload>

handleChange(res, file, fileList) {
      // 将文件放入
      for (let i = 0; i < fileList.length; i++) {
        if (file.name != fileList[i].name) {
          this.fileList.push({
            name: file.name,
            url: "",
            uid: file.uid
          });
        }
      }
      const files = { 0: file };
      this.readExcel(files);
    },

    readExcel(file) {
      const fileReader = new FileReader();

      fileReader.onload = ev => {
        try {
          const data = ev.target.result;
          const workbook = read(data, { type: "binary" });
          const params = [];
          // 取对应表生成json表格内容
          workbook.SheetNames.forEach(item => {
            this.exceltableData.push(utils.sheet_to_json(workbook.Sheets[item]));
          });

          // 该算法仅针对表头无合并的情况
          if (this.exceltableData.length > 0) {
            // 获取excel中第一个表格数据tableData[0][0]，并且将表头提取出来
            for (const key in this.exceltableData[0][0]) {
              this.tableHead.push(key);
            }
          }

          console.log(this.exceltableData[0]) // this.exceltableData[0]就是excel导入的数据

          // 重写数据
        } catch (e) {
          console.log("error:" + e);
          return false;
        }
      };
      fileReader.readAsBinaryString(file[0].raw);


    }