为啥前端导出不在赘述了
第一步:安装xlsx
npm install xlsx
第二步:创建js文件html2excel
import * as XLSX from 'xlsx';const htmlToExcel = {getExcel(dom, title = 'temp'){var excelTitle = title;// const XLSX = require("xlsx");var wb = XLSX.utils.table_to_book(document.querySelector(dom));try {XLSX.writeFile(wb, excelTitle + '.xlsx');} catch (e) {if (typeof console !== 'undefined') {console.log(e);alert('导出失败!');// console.log(e, wbout);}}// return wbout;},
};export default htmlToExcel;
第三步:htmlToExcel.getExcel('#selectTable','导出的自定义标题')导出Excel文件
html2excel.getExcel("#table", "商品价格数据");
总结:适用于数据量不大的表格