后端创文件流前端浏览器进行下载Excel（springboot+Vue）

async exportReport() {
      Axios.get("/sqdb/gwlog/v1/export", {
        params: {},
        responseType: "blob"
      }).then(res => {
        let blob = new Blob([res], {
          type:
            "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
        });
        // console.log(blob);
        let objectUrl = URL.createObjectURL(blob);

        let a = document.createElement("a");
        a.href = objectUrl;
        a.download = "报表";
        // a.click();
        //下面这个写法兼容火狐
        a.dispatchEvent(
          new MouseEvent("click", {
            bubbles: true,
            cancelable: true,
            view: window
          })
        );
        window.URL.revokeObjectURL(blob);
      });
    },