vue导出表格数据
1.下载插件
npm install xlsx --save
npm install file-saver --save
2.引用插件
import XLSX from 'xlsx'
import FileSaver from 'file-saver'
HTML
<el-button @click="exportData" style="margin-bottom: 20px">
导出数据
</el-button>
<el-table ref="tableSort" v-loading="listLoading" :data="list" id="export-table">
...
</el-table>
JS
exportData() {
let wb = XLSX.utils.table_to_book(document.querySelector('#export-table'))
let wbexport = XLSX.write(wb, {
bookType: 'xlsx',
bookSST: true,
type: 'array',
})
try {
FileSaver.saveAs(
new Blob([wbexport], { type: 'application/octet-stream' }),
'测试数据.xlsx'
)
} catch (e) {
if (typeof console !== 'undefined') console.log(e, wbexport)
}
return wbexport
},
导出如下: