1、 使用xlsx。
npm install xlsx --save
<el-table id="tableExcel_Day" :data="tableData" border stripe :height="chatrsTableHeight">
<el-table-column label="时间" align="center" prop="time" />
<el-table-column label="数据质量" align="center" prop="quality" />
<el-table-column :label="valueLabel" align="center" prop="value" />
</el-table>
<el-button size="mini" @click="exportxlsbtn">导出</el-button>
import XLSX from 'xlsx'
exportxlsbtn(){
const workbook = XLSX.utils.table_to_book(document.getElementById('tableExcel_Day'), { raw: true })
const sheet = workbook.Sheets.Sheet1
const wscols = [{ wch: 40 }, { wch: 40 }, { wch: 40 }]
sheet['!cols'] = wscols
XLSX.writeFile(workbook, 'biaoge.xlsx', { bookType: 'xlsx', bookSST: true, type: 'array' })
}
2、 使用xlsx + file-saver
npm install xlsx file-saver --save
<el-table id="tableExcel_Day" :data="tableData" border stripe :height="chatrsTableHeight">
<el-table-column label="时间" align="center" prop="time" />
<el-table-column label="数据质量" align="center" prop="quality" />
<el-table-column :label="valueLabel" align="center" prop="value" />
</el-table>
<el-button size="mini" @click="exportxlsbtn">导出</el-button>
import XLSX from 'xlsx'
import FileSaver from 'file-saver'
exportxlsbtn(){
const xlsxParam = { raw: true }
const wb = XLSX.utils.table_to_book(document.querySelector('#tableExcel_Day'), xlsxParam)
const wbout = XLSX.write(wb, { bookType: 'xlsx', bookSST: true, type: 'array' })
try {
FileSaver.saveAs(new Blob([wbout], { type: 'application/octet-stream' }), `历史数据${this.historyDialogTitle}.xlsx`)
} catch (e) {
if (typeof console !== 'undefined') {
console.log(e, wbout)
}
}
return wbout
}