vue直接导出对应table
const exportClick = () => {
const wb = XLSX.utils.table_to_book(document.querySelector('#newTables'))// 关联dom节点
/* get binary string as output */
const wbout = XLSX.write(wb, {
bookType: 'xlsx',
bookSST: true,
type: 'array',
})
try {
FileSaver.saveAs(new Blob([wbout], {
type: 'application/octet-stream',
}), '库存.xlsx')
}
catch (e) {
// eslint-disable-next-line max-statements-per-line, no-console
if (typeof console !== 'undefined') { console.log(e, wbout) }
}
return wbout
}
- 需要引入的依赖:
import * as XLSX from "xlsx"
import FileSaver from 'file-saver'