12345678910111213141516171819202122232425262728293031 |
- /* import XLSX from 'xlsx'; */
- /*
- 备注:直接传入表格的 columns 和 data即可
- header: [{dataIndex: 'site', title: '地点'}] string Array 标题
- body: [{time: '3点', site: '青岛'}] object Array 数据
- name: '数据导出' string 文件名
- */
- /* export function expoerExcel(header = [], body = [], name = '') {
- // 处理标题
- const dataSource = [], r1 = [];
- header.forEach(item => {
- r1.push(item.title)
- })
- dataSource.push(r1)
- // 处理数据
- body.forEach(b => {
- let r = [];
- header.forEach(h => {
- r.push(b[h.dataIndex])
- })
- dataSource.push(r)
- })
- const worksheet = XLSX.utils.aoa_to_sheet(dataSource);
- const new_workbook = XLSX.utils.book_new();
- XLSX.utils.book_append_sheet(new_workbook, worksheet, 'sheet1');
- XLSX.writeFile(new_workbook, `${name || '导出报表'}.xlsx`);
- } */
|