- 下载xlsx 并引入: import * as XLSX from "xlsx";
- 给需要下载的表格绑定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);
};