<el-button type="primary" size="mini" icon="el-icon-upload" @click="derivePrivateWire">导出</el-button>
<el-table
id="table"
:data="privateTable"
style="width: 100%">
<el-table-column
prop="stationName"
label="车站"
align="center">
</el-table-column>
</el-table>
import FileSaver from 'file-saver'
import XLSX from 'xlsx'
derivePrivateWire() {
if (this.privateTable.length === 0) {
return this.$message.warning('暂无数据,无需导出')
}
let wb = XLSX.utils.table_to_book(document.querySelector('#table'))
let 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
}