引入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");}},