前端导出表格方法

发布时间 2023-03-22 21:09:08作者: kaookiee
exportMyReport(){
      let userInfo = JSON.parse(this.user)
      let data = new FormData();//接口参数格式
      data.append('userid',userInfo.userId);
      data.append('roleid',userInfo.roleId);
      data.append('ssjb',userInfo.ssjb);
      data.append('title',this.formInline.user2_1);
      data.append('year',this.year1);
      data.append('month',this.month1);
      data.append('audit',this.formInline.region2_1);
      this.axios({
        method:'post',//接口方法
        data:data,//接口参数
        url:this.$Api.riskDisaster.myReportExport,//接口地址
        responseType:'blob',
      }).then(res=>{
        let objectUrl = window.URL.createObjectURL(new Blob([res]));
        const elink = document.createElement('a');
        elink.download = `上报列表统计表.xlsx`;//下载后表格的名称
        elink.style.display = 'none';
        elink.href = objectUrl;
        document.body.appendChild(elink);
        elink.click();
        document.body.removeChild(elink);
        window.URL.revokeObjectURL(elink.href); // 释放URL 对象
      })
    },