vue 导出excel文件
import { downloadBinary } from '@/utils/index'
import axios from 'axios'
// 导出文件xls
export function downloadBinary(data, fileName="table.xls") {
let blob = data;
const reader = new FileReader();
reader.readAsDataURL(blob); // 转换为base64,可以直接放入a标签href
reader.onload = e => {
// 转换完成,创建一个a标签用于下载
let a = document.createElement("a");
a.style.display = "none";
a.download = fileName;
a.href = e.target.result;
const body = document.body;
document.body.appendChild(a); // 修复firefox中无法触发click
a.click();
document.body.removeChild(a);
};
}
leadingOut() {
var { beginDate, endDate,sourceChannelCode} = this.searchForm
var query = {
beginDate: beginDate ? beginDate : null,
endDate: endDate ? endDate : null,
sourceChannelCode: sourceChannelCode !== null ? parseInt(sourceChannelCode) : '',
}
console.log(query,'====',process.env.VUE_APP_BASE_API )
let baseUrl = process.env.VUE_APP_BASE_API == '/' ? '' : process.env.VUE_APP_BASE_API;
axios.get(`${baseUrl}/auntportal/v1/report/exportCompleteResumeStatistics?beginDate=${beginDate}&endDate=${endDate}&sourceChannelCode=${query.sourceChannelCode}`, {responseType: 'blob'}).then(res => {
console.log(res,'----')
downloadBinary(res.data,`${query.beginDate}-${query.endDate}简历完善数据统计.xls`)
})
// window.open(`${baseUrl}/auntportal/v1/report/exportCompleteResumeStatistics?beginDate=${beginDate}&endDate=${endDate}&sourceChannelCode=${sourceChannelCode}`)
},