com.fr.io.exporter

类 ExcelExporter

java.lang.Object

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

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

com.fr.io.exporter.ExcelExporter

所有已实现的接口:

AppExporter<java.lang.Boolean>, Exporter

直接已知子类:

LargeDataPageExcelExporter, PageExcelExporter, PageToSheetExcelExporter

public class ExcelExporter
extends AbstractExcelExporter<java.lang.Boolean>

导出报表到Excel

嵌套类概要

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

AbstractExcelExporter.FontAdapter, AbstractExcelExporter.JavaFontAdapter, AbstractExcelExporter.TextFontAdapter

字段概要

字段

限定符和类型	字段和说明
protected boolean	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

构造器概要

构造器

构造器和说明
ExcelExporter() 创建一个ExcelExporter
ExcelExporter(java.util.List paperSettingList) 创建一个ExcelExporter

方法概要

方法

限定符和类型	方法和说明
protected boolean	checkExcelExportVersion()
protected POIFontAction	createFont(POIWorkbookAction wbWrapper, java.awt.Font font)
protected void	dealECReportAndBlockPageSetting(ElementCase report, com.fr.third.org.apache.poi.hssf.usermodel.HSSFSheet hssfSheet, int reportIndex)
protected void	dealWithPageSetting(Report report, com.fr.third.org.apache.poi.hssf.usermodel.HSSFSheet hssfSheet, int reportIndex)
void	export(java.io.OutputStream out, ResultWorkBook book) 导出Workbook 分页报表导出excel例子： WorkBook workbook = (WorkBook) TemplateWorkBookIO.readTemplateWorkBook(FRContext.getCommonOperator(), "1.cpt"); PageRWorkBook book = (PageRWorkBook) workbook.execute(new HashMap(), ActorFactory.getActor("page")); OutputStream os = new FileOutputStream(new File("c:/a.xls")); new ExcelExporter().export(out, book);
void	export(java.io.OutputStream out, ResultWorkBook book, boolean reUse) 导出Workbook
void	export(java.io.OutputStream out, ResultWorkBook book, boolean reUse, int[] sheets) 导出Workbook 填报模板只导出第一个sheet和第二个sheet的例子： WorkBook workbook = (WorkBook) TemplateWorkBookIO.readTemplateWorkBook(FRContext.getCommonOperator(), "1.cpt"); WriteRWorkBook book = (WriteRWorkBook) workbook.execute(new HashMap(), ActorFactory.getActor("write")); OutputStream out = new FileOutputStream(new File("c:/a.xls")); new ExcelExporter().export(out, book, false, new int[] {0, 1});
void	export(java.io.OutputStream out, ResultWorkBook workBook, PageSetCreator pageSet, ReportRepositoryDeal repo, int[] sheets) 导出
protected void	exportFor2003(java.io.OutputStream out, ResultWorkBook book, boolean reUse)
protected void	exportFor2007(java.io.OutputStream out, ResultWorkBook book)
protected AppExporter	getExporterFor2007(java.util.List<PaperSettingProvider> paperSettingList) 获取当前类对应的excel 2007导出类
protected int	getFloatLeftMax(double columnWidth)
protected int	getFloatTopMax(double rowHeight)
protected short	getFormat(POIWorkbookAction wb, java.lang.String pattern)
protected short	getRotation(Style style)
protected POIRichStringAction<com.fr.third.org.apache.poi.hssf.usermodel.HSSFRichTextString>	initRichString(java.lang.String content)
protected void	innerExportReport(Report report, ReportExportAttr exportAttr, java.lang.String sheetName, com.fr.third.org.apache.poi.hssf.usermodel.HSSFWorkbook wb, java.util.List hssfCellList, java.util.List<java.lang.String> hssfCellFormulaList, int reportIndex) Export report,报表不需要再次Execute.
protected void	innerExportReports(ResultECReport innerReport, ResultWorkBook book, POIWorkbookAction hssfWorkbook, java.util.List hssfCellList, java.util.List<java.lang.String> hssfCellFormulaList, java.util.List<Report> reportList, int index)
boolean	isExcel2003() 待说明
void	setVersion(java.lang.Boolean isExcel2003) 设置额外的版本

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

adjustProperFontSize, applyReportHFFooter, applyReportHFHeader, checkInvalidFormula, checkNumberFormat, checkValueVertical, createComplexFont4FR, createSimpleFont, dealWithAlignAndMargin, dealWithBufferImage, dealWithFormula, dealWithHiddenCR, dealWithPrintSetUp, dealWithSumFormula, evalCellValue, evalFormulaValue, evalHtmlContent, executeCellStyle, exportBook, 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

字段详细资料

isExcel2003

protected boolean isExcel2003

构造器详细资料

ExcelExporter

public ExcelExporter()

创建一个ExcelExporter

ExcelExporter

public ExcelExporter(java.util.List paperSettingList)

创建一个ExcelExporter

参数:

paperSettingList - 各个sheet的页面设置的组成的List

方法详细资料

isExcel2003

public boolean isExcel2003()

待说明

返回:

同上

setVersion

public void setVersion(java.lang.Boolean isExcel2003)

从接口复制的说明: AppExporter

设置额外的版本

指定者:

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

覆盖:

setVersion 在类中 AbstractAppExporter<java.lang.Boolean>

参数:

isExcel2003 - 版本

export

public void export(java.io.OutputStream out,
          ResultWorkBook workBook,
          PageSetCreator pageSet,
          ReportRepositoryDeal repo,
          int[] sheets)
            throws java.lang.Exception

从接口复制的说明: AppExporter

导出

指定者:

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

覆盖:

export 在类中 AbstractAppExporter<java.lang.Boolean>

参数:

out - 输出流

workBook - 结果报表

pageSet - 分页集合

repo - 浏览器相关

sheets - sheet索引集合

抛出:

java.lang.Exception - 导出失败则抛出此异常

export

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

导出Workbook 分页报表导出excel例子： WorkBook workbook = (WorkBook) TemplateWorkBookIO.readTemplateWorkBook(FRContext.getCommonOperator(), "1.cpt"); PageRWorkBook book = (PageRWorkBook) workbook.execute(new HashMap(), ActorFactory.getActor("page")); OutputStream os = new FileOutputStream(new File("c:/a.xls")); new ExcelExporter().export(out, book);

指定者:

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

指定者:

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

参数:

out - 输出流

book - 需要导出的Workbook

抛出:

java.lang.Exception - 导出失败则抛出此异常

getExporterFor2007

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

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

抛出:

java.lang.ClassNotFoundException

export

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

导出Workbook

参数:

out - 输出流

book - 需要导出的Workbook

reUse - 是否需要缓存

抛出:

java.lang.Exception

export

public void export(java.io.OutputStream out,
          ResultWorkBook book,
          boolean reUse,
          int[] sheets)
            throws java.lang.Exception

导出Workbook 填报模板只导出第一个sheet和第二个sheet的例子： WorkBook workbook = (WorkBook) TemplateWorkBookIO.readTemplateWorkBook(FRContext.getCommonOperator(), "1.cpt"); WriteRWorkBook book = (WriteRWorkBook) workbook.execute(new HashMap(), ActorFactory.getActor("write")); OutputStream out = new FileOutputStream(new File("c:/a.xls")); new ExcelExporter().export(out, book, false, new int[] {0, 1});

参数:

out - 输出流

book - 需要导出的Workbook

reUse - 是否需要缓存

sheets - 需要导出的sheet序号

抛出:

java.lang.Exception

exportFor2007

protected void exportFor2007(java.io.OutputStream out,
                 ResultWorkBook book)
                      throws java.lang.Exception

抛出:

java.lang.Exception

exportFor2003

protected void exportFor2003(java.io.OutputStream out,
                 ResultWorkBook book,
                 boolean reUse)
                      throws java.lang.Exception

抛出:

java.lang.Exception

checkExcelExportVersion

protected boolean checkExcelExportVersion()

innerExportReports

protected void innerExportReports(ResultECReport innerReport,
                      ResultWorkBook book,
                      POIWorkbookAction hssfWorkbook,
                      java.util.List hssfCellList,
                      java.util.List<java.lang.String> hssfCellFormulaList,
                      java.util.List<Report> reportList,
                      int index)

指定者:

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

innerExportReport

protected void innerExportReport(Report report,
                     ReportExportAttr exportAttr,
                     java.lang.String sheetName,
                     com.fr.third.org.apache.poi.hssf.usermodel.HSSFWorkbook wb,
                     java.util.List hssfCellList,
                     java.util.List<java.lang.String> hssfCellFormulaList,
                     int reportIndex)
                          throws java.lang.Exception

Export report,报表不需要再次Execute.

参数:

report - 需要导出的报表

exportAttr - 报表导出属性

sheetName - 当前sheet的名称

wb - poi处理excel的Workbook

hssfCellList - poi处理excel格子的List

hssfCellFormulaList - poi处理excel中公式的List

reportIndex - 当前报表的Index

抛出:

java.lang.Exception

dealECReportAndBlockPageSetting

protected void dealECReportAndBlockPageSetting(ElementCase report,
                                   com.fr.third.org.apache.poi.hssf.usermodel.HSSFSheet hssfSheet,
                                   int reportIndex)

dealWithPageSetting

protected void dealWithPageSetting(Report report,
                       com.fr.third.org.apache.poi.hssf.usermodel.HSSFSheet hssfSheet,
                       int reportIndex)

getFloatLeftMax

protected int getFloatLeftMax(double columnWidth)

指定者:

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

getFloatTopMax

protected int getFloatTopMax(double rowHeight)

指定者:

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

getRotation

protected short getRotation(Style style)

指定者:

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

createFont

protected POIFontAction createFont(POIWorkbookAction wbWrapper,
                       java.awt.Font font)

指定者:

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

getFormat

protected short getFormat(POIWorkbookAction wb,
              java.lang.String pattern)

指定者:

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

initRichString

protected POIRichStringAction<com.fr.third.org.apache.poi.hssf.usermodel.HSSFRichTextString> initRichString(java.lang.String content)

指定者:

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