1.安装依赖(fs用于保存文件)
npm install xlsx fs -D
2.代码部分
//html
<table ref="tableB"></table>
//js部分
import * as XLSX from "xlsx/xlsx.mjs"; // 导入依赖
specialExport () {
let table_elt = this.$refs.tableB;
//{raw:true} 用于解决将科学计数转成正常数值
let workbook = XLSX.utils.table_to_book(table_elt, { raw: true });
let ws = workbook.Sheets["Sheet1"];
XLSX.utils.sheet_add_aoa(ws, [], {
origin: -1,
});
XLSX.writeFile(workbook, 'xx.xls');
},