vue导出Excel表格,utils未定义是版本原因

1,安装依赖包

npm install --save xlsx
npm install --save file-saver

如果报"TypeError: Cannot read properties of undefined (reading 'utils')"

utils未定义的话需要换一下版本

npm install --save xlsx@0.17.0
npm install --save file-saver@2.0.5

2.给表格添加ref属性

<table ref="exportTableRef"> ... </table>

3.代码段

// 引入导出表格的依赖包
import XLSX from "xlsx";
import FileSaver from "file-saver";

//点击导出
 <a-button @click="exportBtn">导出</a-button>


//methods方法
 exportBtn () {
      // 获取表格元素
      const els = this.$refs.exportTableRef;
      // 文件名
      const filename = "核销订单.xlsx";
      /* generate workbook object from table */
      const wb = XLSX.utils.table_to_book(els);
      /* 或者用id */
      // const wb = XLSX.utils.table_to_book(document.getElementById("id"))
      /* get binary string as output */
      const wbout = XLSX.write(wb, {
        bookType: "xlsx",
        bookSST: true,
        type: "array",
      });
      try {
        FileSaver.saveAs(
          new Blob([wbout], { type: "application/octet-stream" }),
          filename
        );
      } catch (e) {
        console.log(e);
      }
      return wbout;
    },