导出表格代码:
exportHandle() {
exportPreSumData(this.params)
.then(res => {
const blob = new Blob([res]);
const fileName = '报表.xls';
const elink = document.createElement('a');
elink.download = fileName;
elink.style.display = 'none';
elink.href = URL.createObjectURL(blob);
document.body.appendChild(elink);
elink.click();
URL.revokeObjectURL(elink.href); // 释放URL 对象
document.body.removeChild(elink);
})
.catch(res => {
this.loading = false;
});
}
注意: 下面的请求一定要加responseType: 'blob',否则导出的表格是乱码哦!
// 导出表格
export function exportPreSumData(data) {
return request({
url: '/support/GzGrid/exportPreSumData',
method: 'post',
data,
responseType: 'blob'
});
}