vue导出excel
<el-table
id='outTable'
v-loading="listLoading"
:data="List"
border
fit
size="mini"
highlight-current-row
:style="{ width: '90%' }"
/>
<div @click="exportExcel">导出</div>
import XLSX from 'xlsx'
import FileSaver from 'file-saver'
exportExcel() {
var xlsxParam = { raw: true }// 转换成excel时,使用原始的格式
var wb = XLSX.utils.table_to_book(document.querySelector('#outTable'), xlsxParam)
var wbout = XLSX.write(wb, {
bookType: 'xlsx',
bookSST: true,
type: 'array'
})
try {
FileSaver.saveAs(
new Blob([wbout], { type: 'application/octet-stream;charset=utf-8' }),
'订单列表.xlsx'
)
} catch (e) {
if (typeof console !== 'undefined') console.log(e, wbout)
}
return wbout
},
正道的光终将来临,当太阳升起的时候,光芒总会普照大地温暖人间。些许的阴霾也终会有被阳光洒满的一天