1.安装前端处理excel文件流需要使用的插件
npm install -S file-saver
npm install -S xlsx
npm install -D script-loader
2.基于blob封装处理excel文件流方法
export function excelDown(res, name = '模版文件.xlsx', type) {
var typ =
type || 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet';
var blob = new Blob([res], { type: typ });
var downloadElement = document.createElement('a');
var href = window.URL.createObjectURL(blob);
downloadElement.href = href;
downloadElement.download = name;
document.body.appendChild(downloadElement);
downloadElement.click();
document.body.removeChild(downloadElement);
window.URL.revokeObjectURL(href);
}
3.在需要导出功能组件中引入
import { excelDown } from "../../../util/utils";
4.导出接口中使用
exportContract() {
post_pub_productPkgList(this.searchForm)
.then(data => {
excelDown(data, "XXXXX文件.xlsx");
})
.catch(err => {
this.$openMessage(err, "error");
});
},