element-ui表格导出(多个表格导出多个sheet)

第一步:安装依赖

npm install  xlsx file-saver  --save

第二步:在组件中导入

import FileSaver from 'file-saver'
import XLSX from 'xlsx'

第三步:1、给对应表格添加id   2、methods中写入方法

outputFile() {
        var workbook = XLSX.utils.book_new();

        /* convert table 'table1' to worksheet named "Sheet1" */
        var ws1 = XLSX.utils.table_to_sheet(document.querySelector('#Table1'));//对应要导出的表格id
        XLSX.utils.book_append_sheet(workbook, ws1, "sheet1");

        /* convert table 'table2' to worksheet named "Sheet2" */
        var ws2 = XLSX.utils.table_to_sheet(document.querySelector('#Table2'));
        XLSX.utils.book_append_sheet(workbook, ws2, "sheet2");

        /* get binary string as output */
        var wbOut = XLSX.write(workbook, {
          bookType: "xlsx",
          bookSST: true,
          type: "array"
        });
        try {
          FileSaver.saveAs(
                  new Blob([wbOut], { type: "application/octet-stream" }),
                  "demo.xlsx"
          );
        } catch (e) {
          if (typeof console !== "undefined") console.log(e, wbOut);
        }
        return wbOut;
      }

第四步:给按钮绑定方法outputFile

上一篇:python+excel数据驱动接口自动化测试(依赖excel生成测试报告)


下一篇:Day13