vue解析Excel

ElementUI的ElUpload上传Excel，解析报错
     import XLSX from 'xlsx'

      let fileReader = new FileReader();
      fileReader.onload = function () {
        try {
          let data = fileReader.result;
          let workbook = XLXS.read(data, {type:"binary"});
          let wsname = workbook.SheetNames[0];
          console.log("文件名,", wsname);
          let ws = XLXS.utils.sheet_to_json(workbook.Sheets[wsname]);
          console.log(ws);
        }catch (e) {
          console.log("怎么了怎么了", e)
          return false;
        }
      }
      fileReader.readAsBinaryString(file.raw);


  1、报错:TypeError: Failed to execute 'readAsBinaryString' on 'FileReader': parameter 1 is not of 'Blob'
  原因：通过el-upload获取到的文件file是封装后的，与普通input type="file"获取的file是不一样的
  解决方案:  file改为file.raw
            fileReader.readAsBinaryString(file.raw);

  2、报错: Error: Cannot read properties of undefined (reading 'read') at FileReader.read
     解决方案: import * as XLSX from 'xlsx'

  3、electron-vue项目中使用fs报错:Module not found: Error: Can't resolve 'fs' in...
     原因:系统默认不支持node，需要将node集成进来
     解决方案: 在vue.config.js的pluginOptions中加入
     pluginOptions:{
       electronBuilder:{
         nodeIntegration:true
       }
     }
     

    readExcelFile(file){
      let fileReader = new FileReader();
      let generateText = this.generateText;
      fileReader.onload = function () {
        try {
          let data = fileReader.result;
          let workbook = XLXS.read(data, {type:"binary"});
          let wsname = workbook.SheetNames[0];
          let tempData = XLXS.utils.sheet_to_json(workbook.Sheets[wsname]);
          // console.log("Excel长度为", tempData.length);
          let excelData = [...tempData];
          console.log("ExcelName=%s, 数据行数=%d", file.raw.name, excelData.length);
          generateText(file.raw.path, file.raw.name, excelData);
        }catch (e) {
          console.log("怎么了怎么了", e)
          return false;
        }
      }
      fileReader.readAsBinaryString(file.raw);

    }

获取Excel表头

let workbook = XLXS.read(data, {type:"binary"});
let wsName = workbook.SheetNames[0];
//获取表头
let tableHeader = XLXS.utils.sheet_to_json(workbook.Sheets[wsName], {header:1})[0];