com.fr.io.exporter.excel.stream

类 StreamExcel2007Exporter<T>

java.lang.Object

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

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

com.fr.io.exporter.excel.stream.StreamExcel2007Exporter<T>

所有已实现的接口:

AppExporter<T>, Exporter

直接已知子类:

Excel2007Exporter, PageExcel2007Exporter, PageToSheetExcel2007Exporter

public class StreamExcel2007Exporter<T>
extends AbstractExcelExporter<T>

导出报表到Excel

嵌套类概要

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

AbstractExcelExporter.FontAdapter, AbstractExcelExporter.JavaFontAdapter, AbstractExcelExporter.TextFontAdapter

字段概要

字段

限定符和类型	字段和说明
protected com.fr.third.v2.org.apache.poi.xssf.usermodel.XSSFCellStyle	defaultXSSFCellStyle
protected com.fr.third.v2.org.apache.poi.ss.usermodel.DataFormat	format

从类继承的字段 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

构造器概要

构造器

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

方法概要

方法

限定符和类型	方法和说明
protected java.lang.Object	checkNumberFormat(java.text.Format cFormat, java.lang.Object value)
POIFontAction	createFont(POIWorkbookAction wbWrapper, java.awt.Font font)
com.fr.third.v2.org.apache.poi.xssf.usermodel.XSSFFont	createFont(com.fr.third.v2.org.apache.poi.xssf.streaming.SXSSFWorkbook wb, java.awt.Font font)
com.fr.third.v2.org.apache.poi.ss.usermodel.CellStyle	createXSSFCellStyle(com.fr.third.v2.org.apache.poi.xssf.streaming.SXSSFWorkbook wb, Style style) Creates Style
protected void	dealWithFormula(com.fr.third.v2.org.apache.poi.ss.usermodel.Cell xssfCell, java.lang.String contentFormula)
protected java.lang.String	dealWithSumFormula(java.lang.String content, java.lang.Object value, BaseFormula formula, boolean needReExFormula)
java.lang.Object	evalCellValue(CellElement cellElement, boolean exHiddenRow, boolean exHiddenColumn, java.util.List hssfCellList, POICellAction hssfCell, Calculator cal, Style style, java.util.List hssfCellFormulaList, CellGUIAttr cellGUIAttr, DynamicUnitList rowHeightList, DynamicUnitList columnWidthList, int column, int row, int columnSpan, int rowSpan, POIWorkbookAction wb)
void	export(java.io.OutputStream out, ResultWorkBook book) 导出Workbook
void	export(java.io.OutputStream out, ResultWorkBook book, boolean reUse) 导出Workbook
POIPictureLocation	getFloatElementLocation(FloatElement floatElement, DynamicUnitList rowHeightList, DynamicUnitList columnWidthList, ElementCase report, java.lang.Object value)
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.v2.org.apache.poi.xssf.usermodel.XSSFRichTextString>	initRichString(java.lang.String content)
protected void	innerExportReport(Report report, ReportExportAttr exportAttr, java.lang.String sheetName, com.fr.third.v2.org.apache.poi.xssf.streaming.SXSSFWorkbook wb, java.util.List xssfCellList, java.util.List xssfCellFormulaList, int reportIndex) Export report,报表不需要再次Execute.
protected void	innerExportReports(ResultECReport innerReport, ResultWorkBook book, POIWorkbookAction xssfWorkbook, java.util.List xssfCellList, java.util.List<java.lang.String> xssfCellFormulaList, java.util.List<Report> reportList, int index)
void	setColumnRowBreak(CellElement cellElement, POISheetAction sheet, int column, int row, int lastColumn, int lastRow) 设置Excel中的行列分页点

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

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

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

export, export, export, setVersion

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

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

字段详细资料

defaultXSSFCellStyle

protected com.fr.third.v2.org.apache.poi.xssf.usermodel.XSSFCellStyle defaultXSSFCellStyle

format

protected com.fr.third.v2.org.apache.poi.ss.usermodel.DataFormat format

构造器详细资料

StreamExcel2007Exporter

public StreamExcel2007Exporter()

创建一个ExcelExporter

StreamExcel2007Exporter

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

创建一个ExcelExporter

参数:

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

方法详细资料

export

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

导出Workbook

指定者:

export 在接口中 AppExporter<T>

指定者:

export 在类中 AbstractExcelExporter<T>

参数:

out - 输出流

book - 需要导出的Workbook

抛出:

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

export

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

导出Workbook

参数:

out - 输出流

book - 需要导出的Workbook

reUse - 是否需要缓存

抛出:

java.lang.Exception

dealWithFormula

protected void dealWithFormula(com.fr.third.v2.org.apache.poi.ss.usermodel.Cell xssfCell,
                   java.lang.String contentFormula)

dealWithSumFormula

protected java.lang.String dealWithSumFormula(java.lang.String content,
                                  java.lang.Object value,
                                  BaseFormula formula,
                                  boolean needReExFormula)

覆盖:

dealWithSumFormula 在类中 AbstractExcelExporter<T>

innerExportReports

protected void innerExportReports(ResultECReport innerReport,
                      ResultWorkBook book,
                      POIWorkbookAction xssfWorkbook,
                      java.util.List xssfCellList,
                      java.util.List<java.lang.String> xssfCellFormulaList,
                      java.util.List<Report> reportList,
                      int index)

指定者:

innerExportReports 在类中 AbstractExcelExporter<T>

checkNumberFormat

protected java.lang.Object checkNumberFormat(java.text.Format cFormat,
                                 java.lang.Object value)

覆盖:

checkNumberFormat 在类中 AbstractExcelExporter<T>

innerExportReport

protected void innerExportReport(Report report,
                     ReportExportAttr exportAttr,
                     java.lang.String sheetName,
                     com.fr.third.v2.org.apache.poi.xssf.streaming.SXSSFWorkbook wb,
                     java.util.List xssfCellList,
                     java.util.List xssfCellFormulaList,
                     int reportIndex)
                          throws java.lang.Exception

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

参数:

report - 需要导出的报表

exportAttr - 报表导出属性

sheetName - 当前sheet的名称

wb - poi处理excel的Workbook

xssfCellList - poi处理excel格子的List

xssfCellFormulaList - poi处理excel中公式的List

reportIndex - 当前报表的Index

抛出:

java.lang.Exception

getFloatLeftMax

protected int getFloatLeftMax(double columnWidth)

指定者:

getFloatLeftMax 在类中 AbstractExcelExporter<T>

getFloatTopMax

protected int getFloatTopMax(double rowHeight)

指定者:

getFloatTopMax 在类中 AbstractExcelExporter<T>

evalCellValue

public java.lang.Object evalCellValue(CellElement cellElement,
                             boolean exHiddenRow,
                             boolean exHiddenColumn,
                             java.util.List hssfCellList,
                             POICellAction hssfCell,
                             Calculator cal,
                             Style style,
                             java.util.List hssfCellFormulaList,
                             CellGUIAttr cellGUIAttr,
                             DynamicUnitList rowHeightList,
                             DynamicUnitList columnWidthList,
                             int column,
                             int row,
                             int columnSpan,
                             int rowSpan,
                             POIWorkbookAction wb)

覆盖:

evalCellValue 在类中 AbstractExcelExporter<T>

createXSSFCellStyle

public com.fr.third.v2.org.apache.poi.ss.usermodel.CellStyle createXSSFCellStyle(com.fr.third.v2.org.apache.poi.xssf.streaming.SXSSFWorkbook wb,
                                                                        Style style)

Creates Style

getRotation

protected short getRotation(Style style)

指定者:

getRotation 在类中 AbstractExcelExporter<T>

createFont

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

指定者:

createFont 在类中 AbstractExcelExporter<T>

setColumnRowBreak

public void setColumnRowBreak(CellElement cellElement,
                     POISheetAction sheet,
                     int column,
                     int row,
                     int lastColumn,
                     int lastRow)

从类复制的说明: AbstractExcelExporter

设置Excel中的行列分页点

覆盖:

setColumnRowBreak 在类中 AbstractExcelExporter<T>

参数:

cellElement - 当前单元格

sheet - 当前报表sheet

column - 当前列

row - 当前行

lastColumn - 上一个单元格处理的列

lastRow - 上一个单元格处理的行

createFont

public com.fr.third.v2.org.apache.poi.xssf.usermodel.XSSFFont createFont(com.fr.third.v2.org.apache.poi.xssf.streaming.SXSSFWorkbook wb,
                                                                java.awt.Font font)

getFormat

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

指定者:

getFormat 在类中 AbstractExcelExporter<T>

initRichString

protected POIRichStringAction<com.fr.third.v2.org.apache.poi.xssf.usermodel.XSSFRichTextString> initRichString(java.lang.String content)

指定者:

initRichString 在类中 AbstractExcelExporter<T>

getFloatElementLocation

public POIPictureLocation getFloatElementLocation(FloatElement floatElement,
                                         DynamicUnitList rowHeightList,
                                         DynamicUnitList columnWidthList,
                                         ElementCase report,
                                         java.lang.Object value)