vue 导出 excel文件

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}`)
      },