首先安装
npm install js-export-excel
引入
import ExportJsonExcel from 'js-export-excel';
然后看我们定写的组件直接复制即可(接收三个参数1.文件名2.表头3.table数据)
export function exportExcel(fileName, columns, tableData) {
tableData.map(obj=>{
for(const key of Object.keys(obj)){
console.log("obj[key]",obj[key])
obj[key] = obj[key] instanceof Object ? obj[key].valueInput : obj[key]
}
return obj
})
console.log("tableData",tableData)
const option = {};
const sheetData = tableData || [];
const sheetFilter = [];
const sheetHeader = [];
columns
.filter((obj) => !['action', 'colStatus'].includes(obj.key))
.forEach((item) => {
sheetFilter.push(item.key);
sheetHeader.push(item.title);
});
option.fileName = fileName;
option.datas = [
{
sheetData,
sheetName: 'sheet',
sheetFilter,
sheetHeader
},
];
console.log("option",option)
var toExcel = new ExportJsonExcel(option);
toExcel.saveExcel();
}