第一种
getExcel() {
const url = 'URL地址';
this.$http.post(url, this.filter, {
responseType: 'blob'
}).then(res => {
let blob = new Blob([res.data], {
type: "application/vnd.ms-excel",
});
let objectUrl = URL.createObjectURL(blob);
window.location.href = objectUrl;
}).catch(err => {
console.warn(err);
});
},
第二种
//导出Excel
getExcel() {
const url = '你的URL';
this.$http.post(url, params, {
responseType: 'blob'
}).then(res => {
let blob = new Blob([res.data], {
type: 'application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
})
if (window.navigator.msSaveOrOpenBlob) {
navigator.msSaveBlob(blob);
} else {
let elink = document.createElement('a');
elink.download = "报表.xls";
elink.style.display = 'none';
elink.href = URL.createObjectURL(blob);
document.body.appendChild(elink);
elink.click();
document.body.removeChild(elink);
}
}).catch(err => {
console.warn(err);
});
},
第三种
let params = {
shopId: row.shopId,
siteId: row.siteId,
scheduleDate: row.scheduleDate,
siteCardType: this.type
}
const url = '/activity/c/vorder/stieDate2Excel';
this.$axios.get(url, {
params: {
shopId: row.shopId,
siteId: row.siteId,
scheduleDate: row.scheduleDate,
siteCardType: this.type
},
responseType: 'blob',
},
).then(res => {
console.log(res);
let blob = new Blob([res.data], {
type: 'application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
})
if (window.navigator.msSaveOrOpenBlob) {
navigator.msSaveBlob(blob);
} else {
let elink = document.createElement('a');
elink.download = "报表.xls";
elink.style.display = 'none';
elink.href = URL.createObjectURL(blob);
document.body.appendChild(elink);
elink.click();
document.body.removeChild(elink);
}
}).catch(err => {
console.warn(err);
});
文件流导出
于 2022-03-03 17:00:51 首次发布