导入
npm install --save xlsx file-saver
使用方式 exportExcel(“表格的id”,'''导出excel的文件名')
exportExcel.js
import FileSaver from 'file-saver'
import XLSX from 'xlsx'
export default {
exportExcel(id,title) {
var xlsxParam = {
raw: true
}
var wb = XLSX.utils.table_to_book(
document.querySelector('#' +id),
xlsxParam
)
var wbout = XLSX.write(wb, {
bookType: 'xlsx',
bookSST: true,
type: 'array'
})
try {
FileSaver.saveAs(
new Blob([wbout], {
type: 'application/octet-stream'
}),
title + '.xlsx'
)
} catch (e) {
if (typeof console !== 'undefined') console.log(e, wbout)
}
return wbout
}
}