// 下载表格
export const ExportExcel = (url, data, fileName, method = 'POST') => {
return new Promise((resolve, reject) => {
axios.request({
method,
url,
data,
responseType: "blob",
})
.then((res) => {
const link = document.createElement("a");
let blob = new Blob([res.data], {
type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
});
link.style.display = "none";
link.href = URL.createObjectURL(blob);
const DAY = new Date().getFullYear() + '-' + (new Date().getMonth() + 1) + '-' + new Date().getDate()
link.download = fileName + DAY; // 下载的文件名
document.body.appendChild(link);
link.click();
document.body.removeChild(link);

resolve(res)
})
.catch(err => {
reject(err)
});
})
}

调用之前导入

import { ExportExcel } from "./api/index";

使用

getExportExl(datas) {
this.downFile = true
ExportExcel('/saas/api/bookingCabinsStatus/exportPreList', datas, '预配清单').then(res => {
this.downFile = false
}).catch(err => {
this.downFile = false
})
}

主要是excel post方式