<el-button class="export_btn" type="primary" size="small" @click="handleExport">导出</el-button>
<el-table id="exportTable">
<template v-for="(col,index) in columns">
<el-table-column :key="index" align="center" :prop="col.prop" :label="col.label" :width="col.width">
</el-table-column>
</template>
</el-table>
两个第三方插件
import FileSaver from 'file-saver'
import XLSX from 'xlsx'
// 导出
handleExport () {
/* generate workbook object from table */
var xlsxParam = { raw: true } // 导出的内容只做解析,不进行格式转换
var wb = XLSX.utils.table_to_book(document.querySelector('#exportTable'), xlsxParam)
/* get binary string as output */
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
},
table数据导出
最新推荐文章于 2023-09-19 15:19:10 发布