easyPoi导出excel

//相同的detailid，intern() 确保都是拿的常量池的对象，内存地址一样
public void exportAll(HttpServletResponse response, String loanPlatform, String serialNumber, String startTime, String endTime,
                          String loanDiscountType, Integer exceptionStatus, Integer useStatus) {
        statementService.exportAll(response, loanPlatform, serialNumber, startTime, endTime, loanDiscountType, exceptionStatus, useStatus);
    }
@Override
    public void exportAll(HttpServletResponse response, String loanPlatform, String serialNumber, String startTime, String endTime, String loanDiscountType, Integer exceptionStatus, Integer useStatus) {
        List<StatementExcelExportVO> list = statementMapper.exportAll(loanPlatform, serialNumber, startTime, endTime, loanDiscountType, exceptionStatus, useStatus);
        list.forEach(n -> {
            if (StringUtils.isBlank(n.getSchoolId())) {
                n.setSchoolType("异常");
                n.setSchoolName("名称错误");
            }
            if (ObjectUtils.isEmpty(n.getLenderId())) {
                n.setLenderName("异常");
            }
        });
        Workbook sheets = ExcelExportUtil.exportExcel(new ExportParams(), StatementExcelExportVO.class, list);
        // 指定下载的文件名--设置响应头
        response.setContentType("application/vnd.ms-excel;charset=utf-8");
        response.setHeader("Content-Disposition", "attachment;filename=" + URLUtil.encode("贷款流水信息") + ".xls");
        //导出xlsx使用以下设置
        //response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");
        //response.setHeader("Content-Disposition","attachment;filename="+URLUtil.encode("学生信息")+".xlsx");
        try {
            OutputStream output = response.getOutputStream();
            BufferedOutputStream bufferedOutPut = new BufferedOutputStream(output);
            sheets.write(bufferedOutPut);
            bufferedOutPut.flush();
            bufferedOutPut.close();
            output.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }