vue element el-table导出多个sheet页的excel

安装依赖 file-saver xlsx

npm install file-saver xlsx -S

页面引入依赖

import FileSaver from 'file-saver';
import * as XLSX from 'xlsx';

el-table 加标识

<el-table id="out-table1"></el-table>
<el-table id="out-table2"></el-table>

将tabe转为sheet

var sheet1 = XLSX.utils.table_to_sheet(document.querySelector("#out-table1"))
var sheet2 = XLSX.utils.table_to_sheet(document.querySelector("#out-table2"))

将sheet放入workbook

var wb = XLSX.utils.book_new()
XLSX.utils.book_append_sheet(wb, sheet1, "sheet1名称")
XLSX.utils.book_append_sheet(wb, sheet2, "sheet2名称")

导出

var wbout = XLSX.write(wb, {
                bookType: "xlsx",
                bookSST: true,
                type: "array"
            });
            try {
                FileSaver.saveAs(
                    new Blob([wbout], { type: "application/octet-stream" }),
                    "文件名.xlsx"
                );
            } catch (e) {
                console.log('导出失败', e)
            }