表格分页后,突然有需求,说是要把表格导出到excel。可以在导出表格的时候先让表格长度变长,导出后再变回去,就能完整地导出整个表了
exportExcel () {
this.pagesize = '30';//表格长度变长
this.currentPage= '1';
this.$nextTick(function () {
let wb = XLSX.utils.table_to_book(document.querySelector('#srpgtable'));
/* get binary string as output */
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)
}
this.pagesize = '10';//表格还原
return wbout
})
},