我用java实现了一个excel报表，使用apache-poi库，最后我有一个对象列表，有1000条记录，当我遍历这些记录并在报表中写入数据时，花费了太多的时间，我不知道这是否正常。
下面是什么和所有我有工作代码：
控制器类别：
请注意，列表report有1008条记录，最终生成报告时，需要10 minutes
当我调试时，方法writeDataLines()花费了这么多时间。

List<PricingCalculationReport> report =  pricingRuleServiceImpl.applyPricingOnAirshopReport( pricingRequest, agentId );

        log.info( "logging pricing report: " );
        log.debug( objectMapper.writeValueAsString(report) );

        if( report != null ) {
            response.setContentType("application/octet-stream");
            DateFormat dateFormatter = new SimpleDateFormat("yyyy-MM-dd_HH:mm:ss");
            String currentDateTime = dateFormatter.format(new Date());

            String headerKey = "Content-Disposition";
            String headerValue = "attachment; filename=PricingReport_" + currentDateTime + ".xlsx";
            response.setHeader(headerKey, headerValue);

            PricingReporter excelExporter = new PricingReporter(report);

            excelExporter.export(response, new PricingCalculationReport());
        }

报表类，导出方式：

public void export(HttpServletResponse response, PricingCalculationReport report) throws IOException {

    try {
        writeHeaderLine( "Pricing Report", report );
        writeDataLines();

        ServletOutputStream outputStream = response.getOutputStream();
        workbook.write(outputStream);
        workbook.close();

        outputStream.close();
    } catch (Exception e) {
        e.printStackTrace();
    }

}

报表类，writeDataLines方法：

private void writeDataLines() throws Exception {
    int rowCount = 2;

    CellStyle style = workbook.createCellStyle();
    XSSFFont font = workbook.createFont();
    font.setFontHeight(10);
    style.setFont(font);

    for (PricingCalculationReport report : objects) {
        Row row = sheet.createRow(rowCount++);
        int columnCount = 0;

        createCell(row, columnCount++, report.getOfferId(), style);
        createCell(row, columnCount++, report.getOfferItemId(), style);
        createCell(row, columnCount++, report.getRuleName(), style);
        createCell(row, columnCount++, report.getFareType().name(), style);
        createCell(row, columnCount++, report.getAdjustmentType().name(), style);
        createCell(row, columnCount++, report.getAdjustmentValue(), style);
        createCell(row, columnCount++, report.getIsVisible(), style);
        createCell(row, columnCount++, report.getOfferItemBaseAmount(), style);
        createCell(row, columnCount++, report.getOfferItemTaxAmount(), style);
        createCell(row, columnCount++, report.getOfferItemTotalAmount(), style);
        createCell(row, columnCount++, report.getNewOfferItemBaseAmount(), style);
        createCell(row, columnCount++, report.getNewOfferItemTotalAmount(), style);
        createCell(row, columnCount++, report.getOfferBaseAmount(), style);
        createCell(row, columnCount++, report.getOfferTaxAmount(), style);
        createCell(row, columnCount++, report.getOfferTotalAmount(), style);
        createCell(row, columnCount++, report.getNewOfferBaseAmount(), style);
        createCell(row, columnCount++, report.getNewOfferTotalAmount(), style);
        createCell(row, columnCount++, report.getOfferItemMarkupCalculated(), style);
        createCell(row, columnCount++, report.getOfferMarkupCalculated(), style);

    }
}

创建单元格方法：

private void createCell(Row row, int columnCount, Object value, CellStyle style) {
    sheet.autoSizeColumn(columnCount);
    Cell cell = row.createCell(columnCount);
    if (value instanceof Integer) {
        cell.setCellValue((Integer) value);
    } else if (value instanceof Double) {
        cell.setCellValue((Double) value);
    } else if (value instanceof Boolean) {
        cell.setCellValue((Boolean) value);
    } else if (value instanceof BigDecimal) {
        cell.setCellValue( ((BigDecimal) value).doubleValue()  );
    } else {
        cell.setCellValue((String) value);
    }
    cell.setCellStyle(style);
}

报告者类别：

public class PricingReporter {

   private XSSFWorkbook workbook;
   private XSSFSheet sheet;
   private List<PricingCalculationReport> objects;

   public PricingReporter(List<PricingCalculationReport> objects) {
       this.objects = objects;
       workbook = new XSSFWorkbook();
   }
}

谢谢你的建议。