com.fr.io.exporter

类 PageToSheetExcelExporter

java.lang.Object

com.fr.io.exporter.AbstractAppExporter<T>

com.fr.io.exporter.AbstractExcelExporter<java.lang.Boolean>

com.fr.io.exporter.ExcelExporter

com.fr.io.exporter.PageToSheetExcelExporter

所有已实现的接口:

AppExporter<java.lang.Boolean>, Exporter

public class PageToSheetExcelExporter
extends ExcelExporter

carl:一页一个Sheet导出

嵌套类概要

从类继承的嵌套类/接口 com.fr.io.exporter.AbstractExcelExporter

AbstractExcelExporter.FontAdapter, AbstractExcelExporter.JavaFontAdapter, AbstractExcelExporter.TextFontAdapter

字段概要

从类继承的字段 com.fr.io.exporter.ExcelExporter

isExcel2003

从类继承的字段 com.fr.io.exporter.AbstractExcelExporter

A3_PAGE_SIZE, A6_PAGE_SIZE, B4_PAGE_SIZE, B5_PAGE_SIZE, colorList, columnRowPostileMaps, DEFAULT_COL_WIDTH, DEFAULT_FONT, DEFAULT_SCALE, EIGHTH, ex_tool, EXCEL_EXPORT_RESOLUTION, FONT_SCALE, FORMULA_ERROR, HANDRED, HEIGHT_LIMIT, hssfCellStyleHash, hssfFontHash, LEDGER_PAGE_SIZE, MAX_PROPER_FONT, NOTE_PAGE_SIZE, paperSettingList, PICTURE_TYPE_PNG, ROTATION_DOWN, ROTATION_UPPER, sheets2Export, totalBreak

构造器概要

构造器

构造器和说明
PageToSheetExcelExporter(java.util.List<PaperSettingProvider> paperSettingList)

方法概要

方法

限定符和类型	方法和说明
void	export(java.io.OutputStream out, ResultWorkBook book) 分頁分sheet导出 分页分sheet导出的例子： PageRWorkBook book = (PageRWorkBook) workbook.execute(new HashMap(), ActorFactory.getActor("page")); PageToSheetExcelExporter ps = new PageToSheetExcelExporter(ReportUtils.getPaperSettingListFromWorkBook(book)); OutputStream os = new FileOutputStream(new File("c:/a.xls")); ps.export(os, book);
protected void	exportBook(ResultWorkBook book, POIWorkbookAction workbookWrapper, java.util.List cellList, java.util.List<java.lang.String> cellFormulaList, java.util.List<Report> reportList, boolean reUse) 将报表导出成excel
protected AppExporter	getExporterFor2007(java.util.List<PaperSettingProvider> paperSettingList) 获取当前类对应的excel 2007导出类

从类继承的方法 com.fr.io.exporter.ExcelExporter

checkExcelExportVersion, createFont, dealECReportAndBlockPageSetting, dealWithPageSetting, export, export, export, exportFor2003, exportFor2007, getFloatLeftMax, getFloatTopMax, getFormat, getRotation, initRichString, innerExportReport, innerExportReports, isExcel2003, setVersion

从类继承的方法 com.fr.io.exporter.AbstractExcelExporter

adjustProperFontSize, applyReportHFFooter, applyReportHFHeader, checkInvalidFormula, checkNumberFormat, checkValueVertical, createComplexFont4FR, createSimpleFont, dealWithAlignAndMargin, dealWithBufferImage, dealWithFormula, dealWithHiddenCR, dealWithPrintSetUp, dealWithSumFormula, evalCellValue, evalFormulaValue, evalHtmlContent, executeCellStyle, exportBook, getMapBorder, getPassword, html2HSSFRichTextString, isShowAsImage, loadPicture, locateFloatElementInExcel, replaceNewLineChar, setAttr4ECReportSIL, setColumnRowBreak, setDefaultFont, setPostilMap, setSheetName, setSheets2Export

从类继承的方法 com.fr.io.exporter.AbstractAppExporter

export, export

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

构造器详细资料

PageToSheetExcelExporter

public PageToSheetExcelExporter(java.util.List<PaperSettingProvider> paperSettingList)

方法详细资料

export

public void export(java.io.OutputStream out,
          ResultWorkBook book)
            throws java.lang.Exception

分頁分sheet导出 分页分sheet导出的例子： PageRWorkBook book = (PageRWorkBook) workbook.execute(new HashMap(), ActorFactory.getActor("page")); PageToSheetExcelExporter ps = new PageToSheetExcelExporter(ReportUtils.getPaperSettingListFromWorkBook(book)); OutputStream os = new FileOutputStream(new File("c:/a.xls")); ps.export(os, book);

指定者:

export 在接口中 AppExporter<java.lang.Boolean>

覆盖:

export 在类中 ExcelExporter

参数:

out - 输出流

book - 需要导出的Workbook

抛出:

java.lang.Exception

getExporterFor2007

protected AppExporter getExporterFor2007(java.util.List<PaperSettingProvider> paperSettingList)
                                  throws java.lang.ClassNotFoundException

从类复制的说明: ExcelExporter

获取当前类对应的excel 2007导出类

覆盖:

getExporterFor2007 在类中 ExcelExporter

抛出:

java.lang.ClassNotFoundException

exportBook

protected void exportBook(ResultWorkBook book,
              POIWorkbookAction workbookWrapper,
              java.util.List cellList,
              java.util.List<java.lang.String> cellFormulaList,
              java.util.List<Report> reportList,
              boolean reUse)
                   throws java.lang.Exception

从类复制的说明: AbstractExcelExporter

将报表导出成excel

覆盖:

exportBook 在类中 AbstractExcelExporter<java.lang.Boolean>

参数:

book - 结果报表

workbookWrapper - 导出的excel表

cellList - 单元格列表

cellFormulaList - 单元格保留公式列表

reportList - 报表集合

reUse - 是否可以重用

抛出:

java.lang.Exception