vue 导出excel

1、如果后台数据是json格式的话就用如下方法：

  exports() {
      //导出
      var url = " ";
      this.$axios
        ._axios({
          url: url,
          method: "get"
          //  responseType: "blob",
        })
        .then(res => {
          console.log(res);
          this.$exportExcel(res.data, "商品信息");
        })
        .catch(err => {
          console.log(err);
        });
    },
       $exportExcel(data, name) {
      console.log(data);
      console.log(name);
      let blob = new Blob([data], {
        type: "application/vnd.ms-excel"
      });
      let url = window.URL.createObjectURL(blob);
      let a = document.createElement("a");
      a.href = url;
      a.download = name + ".xlsx";
      a.click();
      window.URL.revokeObjectURL(url);
    },

2、如果后台数据是二进制数据流就用如下方法：

    exportsn() {
      //导出
      var url = " ";
      let searchlist = {
        search: {
          is_del: this.formSearch.search.is_del,
          category_id: this.formSearch.search.category_id,
          content: this.formSearch.search.content,
          type: this.formSearch.search.type,
          brand_id: this.formSearch.search.brand_id
        },
        id: this.formShelves.id
      };
      this.$axios
        .axiose({
          url: url,
          data: qs.stringify(searchlist),
          method: "post",
          responseType: "blob"
        })
        .then(result => {
    if (window.navigator.msSaveOrOpenBlob) {  //兼容ie 浏览器
            let fileName = "商品清单" + ".xlsx";
            navigator.msSaveBlob(result, fileName);
          } else {
            const blob = result;
            const reader = new FileReader();
            reader.readAsDataURL(blob);
            reader.onload = e => {
              const a = document.createElement("a");
              a.download = `商品清单.xlsx`;
              a.href = e.target.result;
              document.body.appendChild(a);
              a.click();
              document.body.removeChild(a);
            };
          }
        })
        .catch(err => {
          console.log(err);
        });
    },