先安装插件npm install --save xlsx file-saver
在对应vue的页面中导入
import { saveAs } from 'file-saver'
import * as XLSX from 'xlsx'
给表格设置id,id="electricTable"
exportExcel: function(fileName) {
// #electricTable为表格的id
const wb = XLSX.utils.table_to_book(document.querySelector('#electricTable'))
const wt = XLSX.write(wb, {
bookType: 'xlsx',
bookSST: true,
type: 'array'
})
try {
saveAs(
new Blob([wt], { type: 'application/octet-stream' }),
fileName + '.xlsx'
)
} catch (e) {
if (typeof console !== 'undefined') console.log(e, wt)
}
},