简单又强大,直接把html里的table导出成excel,家人再也不用担心我的导出了
// 引入 file-saver 和 xlsx
import FileSaver from "file-saver";
import XLSX from "xlsx";
exportToExcel(){
//此处传入table的DOM节点
let et =XLSX.utils.table_to_book(document.querySelector("#report_order_table"));
let etout = XLSX.write(et, {
bookType: "xlsx",
bookSST: true,
type: "array",
});
try {
FileSaver.saveAs(
new Blob([etout], {
type: "application/octet-stream",
}),
`TotalHandingFee-${new Date().toLocaleString()}.xlsx`
); //trade-publish.xlsx 为导出的文件名
} catch (e) {
console.log(e, etout,'导出数据');
}
return etout;
},