安装依赖
npm install file-saver xlsx -S
然后在需要的页面中引入依赖包
import FileSaver from ‘file-saver‘;
import XLSX from ‘xlsx‘;
下面就是导出的方法
// 导出 handle_export() { let workbook = XLSX.utils.book_new(); let ws1 = XLSX.utils.table_to_sheet(document.querySelector(‘#table1‘)); XLSX.utils.book_append_sheet(workbook, ws1, ‘ocs话单‘); let ws2 = XLSX.utils.table_to_sheet(document.querySelector(‘#table2‘)); XLSX.utils.book_append_sheet(workbook, ws2, ‘oocp订单‘); let wbout = XLSX.write(workbook, { bookType: ‘xlsx‘, bookSST: true, type: ‘array‘ }); try { FileSaver.saveAs( new Blob([wbout], { type: ‘application/octet-stream‘ }), ‘大单监控.xlsx‘); } catch (e) { if (typeof console !== ‘undefined‘) console.log(e, wbOut); } return wbout; }
原文:https://www.cnblogs.com/florazeng/p/14049151.html