vue导出excel(XLSX)

1、下载安装XLSX

2、引入xlsx文件

3、导出

tableData为表格数据

const data = tableData.map(row => {
    const rowData = {};
    tableCols.forEach(column => {
      rowData[column.label] = row[column.prop];
    });
    return rowData;
  });
  const worksheet = XLSX.utils.json_to_sheet(data);
  const workbook = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
  XLSX.writeFile(workbook, 'exported_table.xlsx');

date数据格式:

 

posted @ 2024-05-21 10:58  cmooc  阅读(687)  评论(0)    收藏  举报