【EasyExcel】EasyExcel导出Excel记录

后端：

    @GetMapping("/exportWaring")
    public void exportWaring(@RequestParam List<Integer> waringIdList, HttpServletResponse response) throws IOException {
        try {
            String filaeName= "Waring-" + DateUtils.format(new Date(), "yyyy-MM-dd") + ".xlsx";
            List<WarningRecordsVo> list = warningRecordsService.exportWaring(waringIdList);
            response.setCharacterEncoding(StandardCharsets.UTF_8.name());
            response.setContentType("application/vnd.ms-excel");
            response.setHeader("Access-Control-Expose-Headers","Content-Disposition");
            response.setHeader("Content-Disposition",
                    "attachment;filename=" + URLEncoder.encode(filaeName, StandardCharsets.UTF_8.name()));
            EasyExcel.write(response.getOutputStream(), WarningRecordsVo.class).autoCloseStream(Boolean.TRUE).sheet().doWrite(list);
        } catch (IOException e) {
            response.reset();
            response.setContentType("application/json");
            response.setCharacterEncoding("utf-8");
            Map<String, String> resultMap = new HashMap<>(2);
            resultMap.put("status", "failure");
            resultMap.put("message", "下载文件失败" + e.getMessage());
            response.getWriter().println(JSON.toJSONString(resultMap));
        }
    }

前端：

  exportWaring(){
    axios({
      method: 'GET',
      url: `/exportWaring1`,
      params: { waringIdList: [] },
      responseType: 'blob'
    }).then(res => {
      console.log(res.headers['content-disposition'])
      console.log("?????????")
      const fileNameCode = res.headers['content-disposition'].split('filename=')[1]
      let iconv = require('iconv-lite');
      let fileName = iconv.decode(fileNameCode, 'UTF-8');
      const blob = new Blob([res.data], { type: 'application/vnd.ms-excel' });
      const url = window.URL.createObjectURL(blob);
      const $a = document.createElement('a');
      $a.style.display = 'none';
      $a.href = url;
      $a.setAttribute('download', fileName);
      $a.click();
    }).catch(err => {
      console.log(err)
    })
},