vue项目导出table数据为excel
import FileSaver from ‘file-saver‘ import XLSX from ‘xlsx‘
"warning" @click="exportForm" icon="el-icon-download" >导出
"listArr" border style="width: 99%" id="mainFrame" > "userName" label="姓名" align="center"> "logMonth" label="日期" align="center"> "scope"> {{scope.row.logMonth | logMonth}}
methods方法:
exportForm() { var wb = XLSX.utils.table_to_book(document.querySelector(‘#mainFrame‘)) // mainFrame table的id var wbout = XLSX.write(wb, { 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/weiweiyeyu/p/15351756.html