修改Export2Excel.js文件头部如下:
require('script-loader!file-saver');
require('./Blob');
const XLSX = require('xlsx/dist/xlsx.core.min');
自定义导出函数excel.js:
export function ExportExcel(name, columns, list) {
require.ensure([], () => {
const { export_json_to_excel } = require("./excel/Export2Excel");
let tHeader = [];
let filterVal = [];
if (!columns) {
return;
}
columns.forEach((item) => {
tHeader.push(item.title);
filterVal.push(item.name);
});
const data = list.map((v) => filterVal.map((j) => v[j]));
export_json_to_excel(tHeader, data, name);
});
}
使用:
const { ExportExcel } = require("@/utils/excel");