前端vue导出文件流excel

后台返回的是文件流 excel,以下代码前端直接导出

1. 获取当前时间 -- 用来对导出文件命名

//获取当前时间
getCurrentTime() {
    let yy = new Date().getFullYear()
    let mm = new Date().getMonth() + 1
    let dd = new Date().getDate()
    let hh = new Date().getHours()
    let mf = new Date().getMinutes() < 10 ? '0' + new Date().getMinutes() : new Date().getMinutes()
    let ss = new Date().getSeconds() < 10 ? '0' + new Date().getSeconds() : new Date().getSeconds()
    this.getTimeExcel = yy + '-' + mm + '-' + dd + '_' + hh + "-" + mf + "-" + ss;
},
           

2. 导出excel事件

/************导出文件**************/
exportData() {
   this.getCurrentTime()
   const getTimeExcel = this.getTimeExcel; //这里获取当前时间用来命名

   if (this.curveModeCurveId == "" || this.curveModeCurveId == null) {  //这里是我自己加的判断
      this.$message({
      type: 'error',
      message: '请选中要导出的曲线!'
      });
   } else {
     exportExcelData('get', {
     curveId: this.curveModeCurveId,
   }, {
      responseType: 'blob',
      headers: {
      'Content-Type': 'application/json'
      },
   }).then(function (res) {
      let blob = new Blob([res], {type: 'application/vnd.ms-excel'});
      if (window.navigator && window.navigator.msSaveOrOpenBlob) {
          window.navigator.msSaveOrOpenBlob(blob, getTimeExcel);
      } else {
          const link = document.createElement('a')
          link.style.display = 'none'
          link.href = URL.createObjectURL(blob)
          link.download = getTimeExcel+'.xls' //这里是文件名
          document.body.appendChild(link)
          link.click()
          document.body.removeChild(link)
       }
    }).catch(function (error) {
       console.log(error);
    })
    }
},

3. 页面直接调用事件即可导出