下载Excel表格

天天向上，冲呀，❤狗崽崽❤

get方式

   // 下载
    downloadTable() {
      this.download(
        window.baseUrl +
          "/downData?参数1=" +
          this.参数1 +
          "&参数2=" +
          this.参数2
      );
    },
    download(url) {
      let a = document.createElement("a");
      a.href = url;
      let _id = Math.random() + Math.random();
      a.id = _id;
      a.click();
      window.URL.revokeObjectURL(url);
    }

post方式

import axios from "axios";  //引入axios

downloadTable() {
	 axios({
	        method: "post",
	        url: window.medicineUrl + "/downShowData", // 请求地址
	        data: {
	          categoryId: 1, 
	          offset: this.offset,
	          limit: this.limit
	        },
	        responseType: "arraybuffer",
	        observe: "response"
	      }).then(res => { 
	          const fileName = "表格名称.xlsx";
	          let blob = new Blob([res.data], {
	            type:
	              "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
	          });
	          if ("download" in document.createElement("a")) {
	            // 非IE下载
	            const elink = document.createElement("a");
	            elink.download = fileName;
	            elink.style.display = "none";
	            elink.href = URL.createObjectURL(blob);
	            document.body.appendChild(elink);
	            elink.click();
	            URL.revokeObjectURL(elink.href); // 释放URL 对象
	            document.body.removeChild(elink);
	          } else {
	            // IE10+下载
	            navigator.msSaveBlob(blob, fileName);
	          }
	})
}，
 download(data) {
      if (!data) {
        return;
      }
      let url = window.URL.createObjectURL(new Blob([data]));
      let link = document.createElement("a");
      link.style.display = "none";
      link.href = url;
      link.setAttribute("download", "excel.xlsx");
      document.body.appendChild(link);
      link.click();
    }