vue使用table2excel导出Execl
- 安装js-table2excel,
- 命令:npm install js-table2excel
- 引入js-table2excel
- 命令:import table2excel from ‘js-table2excel’
- 封装
export let exportExcel = (columnData , sheetData, name?,tableName?) => {
table2excel(columnData, sheetData, name,tableName)
}
- 使用
let list = [{enterpriseName:"数据1",deviceNumber:"数据1",address:"数据1"}]
let columnConfig=[
{ type: "text", key: "enterpriseName", title: "所属区域合作伙伴"},
{ type: "text", key: "deviceNumber", title: "累计设备需求(台)"},
{ type: "text", key: "address", title: "收货信息"},
]
exportExcel(columnConfig,list,'设备需求');