表格增删改查之导出功能

最近在写后台管理系统，有一个导出表格的功能，记录一下

derive() {
const derive_url = “/api/admin/excelOperation/exportExcel”; 
  axios({
    method: "post",
    url: derive_url,
    responseType: "blob",
    data: {
    busClickDto:this.oncederive,
    //this.oncederive,是传给后台的数据，我这里是导出一个数组给后台
    },
  }).then((response) => {
    let fileName = window.decodeURI(
      response.headers["content-disposition"].split("=")[1]
    );
    let link = document.createElement("a");
    link.href = window.URL.createObjectURL(
      new Blob([response.data], {
        type:
          "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8",
      })
    );
    link.target = "_blank";
    link.download = fileName;
    document.body.appendChild(link);
    link.click();
    document.body.removeChild(link);
  });
},