下载插件
npm install --save file-saver@2.0.5
页面引用
import XLSX from "xlsx";
downloadIpList(array){
let title = "1668039445469.xlsx"
//设置表头
let aoa = [["单据编码","补充代码","用户名"]];
//按二维数组顺序加入表格数据
array.forEach((item,index) => {
aoa.push([
item.DocNum,
item.SupplCode,
item.U_NAME,
]);
});
//创建表
let worksheet = XLSX.utils.aoa_to_sheet(aoa);
//创建表格文件
let workbook = XLSX.utils.book_new();
//插入表到表格第一页
XLSX.utils.book_append_sheet(workbook, worksheet, "Sheet1");
XLSX.writeFile(workbook, title);//导出表格
this.loading=false
}