【springboot+easypoi】大数据量excel导出

    @ApiOperation("导出会员盘点情况")
    @PostMapping("exportMemberCheck")
    public ResponseData exportMemberCheck(@RequestBody QueryMemberCheckFB fb,
                                          HttpServletResponse response){
        try {
            validate(fb);

            Date nowTime = new Date();
            String notTimeStr = DateUtils.formatTo(nowTime, "yyyyMMddHHmm");

            QueryMemberCheckDTO dto = mapper.map(fb,QueryMemberCheckDTO.class);

            Workbook workbook = bigExcel(1,null,new ExportParams(EnumExportCode.MEMBER_CHECK.getDesc(), "sheet"),new Page<>(),dto);

            ExcelExportUtil.closeExportBigExcel();
            //执行导出
            downExcel(UcHelper.getUser().getName() + "-" + EnumExportCode.MEMBER_CHECK.getDesc()+"-"+notTimeStr+".xls", response, workbook);
        } catch (ServiceException | IOException se){
            log.error(String.format("导出会员盘点情况失败,失败原因:%s", se.getMessage()), se);
            return ResponseData.newFailed(String.format("导出会员盘点情况失败,失败原因:%s", se.getMessage()));
        }
        return ResponseData.newSuccess("导出成功");
    }

    private Workbook bigExcel(int pageNum, Workbook workbook, ExportParams exportParams, Page<MemberCheckVO> page,QueryMemberCheckDTO dto) {
        //分页查询数据
        dto.setPageNumber(pageNum);
        dto.setPageSize(5000);
        page = memberCheckService.pageMemberCheck(dto);
        List<MemberCheckVO> data = page.getRows();

        workbook = ExcelExportUtil.exportBigExcel(exportParams, MemberCheckVO.class, data);

        //如果不是最后一页，递归查询
        if (page.getTotalPages() > pageNum) {
            bigExcel(pageNum + 1, workbook, exportParams, page, dto);
        }
        return workbook;
    }

    /**
     * 导出数据表格
     * @param fileName
     * @param response
     * @param workbook
     * @throws IOException
     */
    public void downExcel(String fileName, HttpServletResponse response, Workbook workbook)
            throws IOException {
        response.setHeader("content-Type", "application/vnd.ms-excel");
        response.setCharacterEncoding("UTF-8");
        String encodeName = URLEncoder.encode(fileName, "UTF-8");
        encodeName = encodeName.replaceAll("\\+", "%20");
        response.setHeader("Content-Disposition", "attachment;filename=" + encodeName);
        workbook.write(response.getOutputStream());
    }