PageToSheetExcelExporter(ReportUtils.getPaperSettingListFromWorkBook(rworkbook));
//
导
出
2007
版
outputStream
=
new
FileOutputStream(new
File("E:\\PageSheetExcelExport.xlsx")); excel PageToSheetExcel2007Exporter sheet = new
PageToSheetExcel2007Exporter(ReportUtils.getPaperSettingListFromWorkBook(rworkbook));
sheet.export(outputStream, rworkbook);
效果图:
4、
大数据量导出
这是比较常见的,例如以 50000 行为一个 excel 文件
其代码如下:
outputStream = new FileOutputStream(new File("E:\\LargeExcelExport.zip"));
LargeDataPageExcelExporter
large
=
new
LargeDataPageExcelExporter(ReportUtils.getPaperSettingListFromWorkBook(rworkbook), true);
//导出 2007 版 outputStream = new FileOutputStream(new File("E:\\LargeExcelExport.xlsx"));
excel
LargeDataPageExcel2007Exporter
large
=
new
LargeDataPageExcel2007Exporter(ReportUtils.getPaperSettingListFromWorkBook(rworkbook),
true);
large.export(outputStream, rworkbook);
对于大数据量导出报表时,可能会出现如下两种情况: