vue使用xlsx库导出excel
引入xlsx库
import XLSX from "xlsx";
将后端接口返回的数据和列名,拼接到XLSX.utils.aoa_to_sheet中
exportExcel() {debugger;if (!this.feedingTableData || this.feedingTableData.length == "0") {this.$message.error("投料信息为空,不能导出excel");} else {const headers = this.columnList;const body = this.feedingTableData.map((item) =>headers.map((key) => item[key]));const worksheet = XLSX.utils.aoa_to_sheet([headers, ...body]);// 创建工作簿const workbook = XLSX.utils.book_new();// 添加工作表到工作簿XLSX.utils.book_append_sheet(workbook, worksheet, "投料信息");// 导出文件XLSX.writeFile(workbook, "投料信息.xlsx");}},