导出excel文件

一、XMLHttpRequest

 exportFile(){
      let params = {
        deptName: this.sel.deptName,
        params: [
          {
            projectName: this.sel.projectName,
            applyDeptName: this.sel.deptName2,
            contents: this.sel.input
          }
        ]
      }

      let downloadUrl = "/api/search/export"
      //构造函数初始化一个 XMLHttpRequest 对象
      let oReq = new XMLHttpRequest();
      oReq.open("POST", downloadUrl, true);
      //setRequestHeader() 是设置HTTP请求头部的方法。此方法必须在  open() 方法和 send()   之间调用
      oReq.setRequestHeader("Content-type", "application/json;charset=UTF-8");
      //response 是一个包含二进制数据的 Blob 对象 。
      oReq.responseType = "blob";
      oReq.onload = function () {
       // 请求结束后,在此处写处理代码
        var content = oReq.response;
        var blob = new Blob([content]);
        //  创建a标签，下载处理过的文件流
        var elink = document.createElement('a');
        elink.download = "excel文件名.xls";
        elink.href = URL.createObjectURL(blob);
        elink.click();
      };
      
     oReq.send(JSON.stringify(params));
 
    },

    exportExcel(){
	//拼接url
      let downloadUrl = "/api/reception/export_exl?department="+this.excelForm.department+
      "&from="+this.excelForm.from;

      let oReq = new XMLHttpRequest();
      oReq.open("POST", downloadUrl, true);
      oReq.responseType = "blob";
      oReq.onload = function () {
        var content = oReq.response;
        var blob = new Blob([content]);
        //  创建a标签，下载处理过的文件流
        var elink = document.createElement('a');
        elink.download = "excel文件名.xls";
        elink.href = URL.createObjectURL(blob);
        elink.click();
      };
      oReq.send();
    },

二、打开新窗口

exportFile(){
	 //拼接url
      let downloadUrl = '/api/project/downProjectList?‘
      window.open(downloadUrl);
    },