1.安装第三方库如xlsx
2.引入使用:import * as XLSX from "xlsx/xlsx.mjs";
3.编写导出方法:
// 导单行出 excel 表格
handlerExportData(index, row) {
console.log(index, row);
const worksheet = XLSX.utils.json_to_sheet([row]);
// 创建一个新的工作簿(workbook)对象
const workbook = XLSX.utils.book_new();
// 将工作表添加到工作簿中
XLSX.utils.book_append_sheet(workbook, worksheet, "Sheet1");
// 最后,将工作簿写入到一个Excel文件中并命名文件
XLSX.writeFile(workbook, `single_row_export_${row.bookname}.xlsx`);
},
// 导出全部数据为 excel
handleTotalExport() {
const worksheet = XLSX.utils.json_to_sheet(this.tableData);
const workbook = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(workbook, worksheet, "Sheet1");
XLSX.writeFile(workbook, `total_export.xlsx`);
},