后端主导的导出代码前端操作包错

导出xlsx文件到桌面

下载npm i XLSX

设置接口

export const exporjliu=(deviceStrIds,endTime,startTime,timeUnit)=>{
  return request({
    url: 'useelectriccountapi/export',
    method: 'get',

    params: {
      deviceStrIds:deviceStrIds,
      endTime:endTime,
      startTime:startTime,
      timeUnit:timeUnit,

    },
     responseType: 'blob'
  });

}

在设置接口时给每个接口添加 responseType: 'blob'

页面上调用接口

 exportData() {
      console.log("A", this.startTime, this.siteId);
      exportsjiu(this.siteId, this.startTime, 1)
        .then((response) => {
          console.log("接口返回的数据:", response); // 检查返回的数据

          const blob = new Blob([response], {
            type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
          });
          const url = URL.createObjectURL(blob);
          const a = document.createElement("a");
          a.href = url;
          a.download = "电站发电统计周.xlsx";
          document.body.appendChild(a);
          a.click();
          URL.revokeObjectURL(url);
        })
        .catch((error) => {
          console.error("接口调用失败:", error);
        });
    }