安装依赖 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)
}