exportExcel.js 906 B

12345678910111213141516171819202122232425262728293031
  1. /* import XLSX from 'xlsx'; */
  2. /*
  3. 备注:直接传入表格的 columns 和 data即可
  4. header: [{dataIndex: 'site', title: '地点'}] string Array 标题
  5. body: [{time: '3点', site: '青岛'}] object Array 数据
  6. name: '数据导出' string 文件名
  7. */
  8. /* export function expoerExcel(header = [], body = [], name = '') {
  9. // 处理标题
  10. const dataSource = [], r1 = [];
  11. header.forEach(item => {
  12. r1.push(item.title)
  13. })
  14. dataSource.push(r1)
  15. // 处理数据
  16. body.forEach(b => {
  17. let r = [];
  18. header.forEach(h => {
  19. r.push(b[h.dataIndex])
  20. })
  21. dataSource.push(r)
  22. })
  23. const worksheet = XLSX.utils.aoa_to_sheet(dataSource);
  24. const new_workbook = XLSX.utils.book_new();
  25. XLSX.utils.book_append_sheet(new_workbook, worksheet, 'sheet1');
  26. XLSX.writeFile(new_workbook, `${name || '导出报表'}.xlsx`);
  27. } */