导出代码如下:
Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), PriceExcelModel.class, priceExcelModelList);
File file = FileUtil.createFile(PROCEED_DATA_SOURCE_PATH);
workbook.write(new FileOutputStream(file));
workbook.close();
当数据量超过65536时,导出结果为多个sheet,会产生不方便阅读的问题。
如果设置最大sheet行,代码如下:
ExportParams exportParams = newExportParams();
exportParams.setMaxNum(200000);
exportParams.setType(ExcelType.HSSF);
Workbook workbook= ExcelExportUtil.exportExcel(exportParams, PriceExcelModel.class, priceExcelModelList);
File file=FileUtil.createFile(PROCEED_DATA_SOURCE_PATH);
workbook.write(newFileOutputStream(file));
workbook.close();
会产生如下报错,如下代码报错:
ERROR 17:00:02 [org.jeecgframework.poi.excel.export.base.ExportBase:213] Invalid row number (65536) outs