历史版本9 :Excel 导出的多种方式 返回文档
编辑时间:
内容长度:图片数:目录数:
修改原因:
在导出章节中我们介绍了Excel导出方式ExcelExporter,此为原样导出。若是您先前学习过FineReport学习教程,您会知道,在FineReport中,除原样导出外还有另外三种导出方式:分页导出、分页分sheet导出、大数据量导出。在程序中有不同的接口来实现:
原样导出
outputStream = new FileOutputStream(new File("E:\\ExcelExport.xls"));
ExcelExporter excel = new ExcelExporter();
//导出2007版
outputStream = new FileOutputStream(new File("E:\\ExcelExport.xlsx")); excel Excel2007
Exporter excel = new Excel2007Exporter();
excel.export(outputStream, rworkbook);
分页导出
outputStream = new FileOutputStream(new File("E:\\PageExcelExport.xls"));
PageExcelExporter page = new PageExcelExporter(ReportUtils.getPaperSettingListFromWorkBook(rworkbook));
//导出2007版
outputStream = new FileOutputStream(new File("E:\\PageExcelExport.xlsx")); excel PageExcel2007Exporter page = new Page
Excel2007
Exporter(ReportUtils.getPaperSettingListFromWorkBook(rworkbook));
page.export(outputStream, rworkbook);
分页分sheet导出
outputStream = new FileOutputStream(new File("E:\\PageSheetExcelExport.xls"));
PageToSheetExcelExporter sheet = new 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);
大数据量导出,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 LargeDataP
ageExcel2007
Exporter(ReportUtils.getPaperSettingListFromWorkBook(rworkbook), true);
large.export(outputStream, rworkbook);