页面表格导出为excel数据

81 阅读1分钟
  1. 下载xlsx 并引入: import * as XLSX from "xlsx"; image.png
  2. 给需要下载的表格绑定id值,触发下载按钮 downloadExcel方法
const downloadExcel = () => {
  const table = document.getElementById("myTable");
  downloadExcelFile(table, "allPapersTableData.xlsx");
};
const downloadExcelFile = (tableData, fileName) => {
  const worksheet = XLSX.utils.table_to_sheet(tableData);
  const workbook = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(workbook, worksheet, "Sheet1");
  XLSX.writeFile(workbook, fileName);
};