com.fr.io.exporter

类 AbstractExcelExporter<T>

java.lang.Object

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

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

所有已实现的接口:

AppExporter<T>, Exporter

直接已知子类:

ExcelExporter, StreamExcel2007Exporter

public abstract class AbstractExcelExporter<T>
extends AbstractAppExporter<T>

嵌套类概要

嵌套类

限定符和类型	类和说明
static interface	AbstractExcelExporter.FontAdapter
static class	AbstractExcelExporter.JavaFontAdapter
protected static class	AbstractExcelExporter.TextFontAdapter

字段概要

字段

限定符和类型	字段和说明
static short	A3_PAGE_SIZE
static short	A6_PAGE_SIZE
static short	B4_PAGE_SIZE
static short	B5_PAGE_SIZE
protected IntList	colorList
protected java.util.Map[]	columnRowPostileMaps
static short	DEFAULT_COL_WIDTH
protected static short	DEFAULT_FONT
static int	DEFAULT_SCALE
static int	EIGHTH
protected ExcelHiddenCellsTool	ex_tool
static int	EXCEL_EXPORT_RESOLUTION
protected static double	FONT_SCALE
static java.lang.String	FORMULA_ERROR
static double	HANDRED
static int	HEIGHT_LIMIT
protected java.util.HashMap	hssfCellStyleHash
protected java.util.HashMap	hssfFontHash
static short	LEDGER_PAGE_SIZE
protected static int	MAX_PROPER_FONT
static short	NOTE_PAGE_SIZE
protected java.util.List	paperSettingList
static int	PICTURE_TYPE_PNG
protected static int	ROTATION_DOWN
protected static int	ROTATION_UPPER
protected int[]	sheets2Export
protected int	totalBreak

构造器概要

构造器

构造器和说明
AbstractExcelExporter()

方法概要

方法

限定符和类型	方法和说明
protected Style	adjustProperFontSize(Style style) 调整下当前格子导出的字体大小
protected void	applyReportHFFooter(ReportHFProvider reportHF, POIHeaderFooterAction footer) 设置页脚
protected void	applyReportHFHeader(ReportHFProvider reportHF, POIHeaderFooterAction header) 设置页眉
protected boolean	checkInvalidFormula(java.lang.String formulaText) 用FRParser来判断公式是否合法
protected java.lang.Object	checkNumberFormat(java.text.Format cFormat, java.lang.Object value)
protected java.lang.Object	checkValueVertical(java.lang.Object value, Style style, int width, int height)
protected void	createComplexFont4FR(FRFont frFont, POIFontAction font) 复杂点的字体设置, java原生的不带, 字体上下标, 下划线等
protected abstract POIFontAction	createFont(POIWorkbookAction wbWrapper, java.awt.Font font)
protected POIFontAction	createSimpleFont(POIWorkbookAction wb, AbstractExcelExporter.FontAdapter font, POIFontAction fontWrapper, java.lang.String cellFontName) 获取当前字体的样式, 并加以缓存
protected void	dealWithAlignAndMargin(POISheetAction sheet, ReportSettingsProvider reportSettings, Margin margin) 设置是否垂直水平居中, 以及边距
protected void	dealWithBufferImage(java.lang.Object value, POIClientAnchorAction clientAnchor, POIPatriarchAction patriarch, Style style, int width, int height, java.awt.image.BufferedImage buffImg, POIWorkbookAction wb) 将BufferImage转化成excel中的悬浮元素
protected void	dealWithFormula(POICellAction poiCell, java.lang.String contentFormula) 导出保留公式
protected int[]	dealWithHiddenCR(int start, int span, IntList hiddenList)
protected void	dealWithPrintSetUp(POIPrintSetupAction printSetup, PaperSize paperSize, int orientation, ReportSettingsProvider reportSettings) 导出当前报表的打印设置到excel, 包括纸张, 横纵向, 页眉页脚距离
protected java.lang.String	dealWithSumFormula(java.lang.String content, java.lang.Object value, BaseFormula formula, boolean needReExFormula)
protected 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)
protected java.lang.Object	evalFormulaValue(java.lang.Object value, boolean exHiddenRow, boolean exHiddenColumn, java.util.List cellList, POICellAction cell, Calculator cal, java.util.List cellFormulaContentList) 重新计算存在公式的单元格的值
protected java.lang.Object	evalHtmlContent(POIWorkbookAction wb, java.lang.Object value, Style style, int width, int height)
protected void	executeCellStyle(POIWorkbookAction wb, POICellStyleAction hssfCellStyle, Style style) 将报表中的单元格样式设置到excel单元格中
abstract void	export(java.io.OutputStream out, ResultWorkBook workbook) 导出Workbook
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 void	exportBook(ResultWorkBook book, POIWorkbookAction workbookWrapper, java.util.List cellList, java.util.List<java.lang.String> cellFormulaList, java.util.List<Report> reportList, boolean reUse, int[] sheets) 将报表导出成excel
protected abstract int	getFloatLeftMax(double columnWidth)
protected abstract int	getFloatTopMax(double rowHeight)
protected abstract short	getFormat(POIWorkbookAction wb, java.lang.String pattern)
protected short	getMapBorder(int border) 根据报表设置的边框线返回Excel对应的线型
protected java.lang.String	getPassword(ResultWorkBook book) 获取报表中设置的Excel导出保护工作表密码
protected abstract short	getRotation(Style style)
protected POIRichStringAction	html2HSSFRichTextString(POIWorkbookAction wb, java.lang.String html, Style style)
protected abstract POIRichStringAction	initRichString(java.lang.String content)
protected abstract void	innerExportReports(ResultECReport innerReport, ResultWorkBook book, POIWorkbookAction workbook, java.util.List cellList, java.util.List<java.lang.String> cellFormulaList, java.util.List<Report> reportList, int index)
protected boolean	isShowAsImage(int textStyle, CellGUIAttr cellGUIAttr)
protected int	loadPicture(java.awt.image.BufferedImage bufferedImage, POIWorkbookAction wb)
protected POIPictureLocation	locateFloatElementInExcel(FloatElement floatElement, DynamicUnitList rowHeightList, DynamicUnitList columnWidthList, ElementCase report, java.lang.Object value) 定位excel中悬浮元素的位置
protected java.lang.String	replaceNewLineChar(java.lang.String allString) peter:替换成newline
protected void	setAttr4ECReportSIL(Calculator cal, IntList hiddenRowList, IntList hiddenColList, ElementCase report)
protected void	setColumnRowBreak(CellElement cellElement, POISheetAction sheet, int column, int row, int lastColumn, int lastRow) 设置Excel中的行列分页点
protected void	setDefaultFont(POIWorkbookAction hssfWorkbook) 设置导出默认字体
void	setPostilMap(java.util.Map[] columnRowPostileMaps) 设置标识错误的单元格
protected void	setSheetName(POIWorkbookAction wb, java.lang.String name4Sheet) 设置Excelsheet的名字, 同时避免在Workbook中出现重命名现象 限定长度为31个字符
void	setSheets2Export(int[] sheets)

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

export, export, export, setVersion

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

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

字段详细资料

DEFAULT_FONT

protected static final short DEFAULT_FONT

另请参阅:

常量字段值

DEFAULT_COL_WIDTH

public static final short DEFAULT_COL_WIDTH

另请参阅:

常量字段值

PICTURE_TYPE_PNG

public static final int PICTURE_TYPE_PNG

另请参阅:

常量字段值

EXCEL_EXPORT_RESOLUTION

public static final int EXCEL_EXPORT_RESOLUTION

另请参阅:

常量字段值

FORMULA_ERROR

public static final java.lang.String FORMULA_ERROR

MAX_PROPER_FONT

protected static final int MAX_PROPER_FONT

另请参阅:

常量字段值

FONT_SCALE

protected static final double FONT_SCALE

另请参阅:

常量字段值

A3_PAGE_SIZE

public static final short A3_PAGE_SIZE

另请参阅:

常量字段值

A6_PAGE_SIZE

public static final short A6_PAGE_SIZE

另请参阅:

常量字段值

B4_PAGE_SIZE

public static final short B4_PAGE_SIZE

另请参阅:

常量字段值

B5_PAGE_SIZE

public static final short B5_PAGE_SIZE

另请参阅:

常量字段值

NOTE_PAGE_SIZE

public static final short NOTE_PAGE_SIZE

另请参阅:

常量字段值

LEDGER_PAGE_SIZE

public static final short LEDGER_PAGE_SIZE

另请参阅:

常量字段值

ROTATION_UPPER

protected static final int ROTATION_UPPER

另请参阅:

常量字段值

ROTATION_DOWN

protected static final int ROTATION_DOWN

另请参阅:

常量字段值

HANDRED

public static final double HANDRED

另请参阅:

常量字段值

DEFAULT_SCALE

public static final int DEFAULT_SCALE

另请参阅:

常量字段值

HEIGHT_LIMIT

public static final int HEIGHT_LIMIT

另请参阅:

常量字段值

EIGHTH

public static final int EIGHTH

另请参阅:

常量字段值

paperSettingList

protected java.util.List paperSettingList

hssfFontHash

protected java.util.HashMap hssfFontHash

hssfCellStyleHash

protected java.util.HashMap hssfCellStyleHash

colorList

protected IntList colorList

columnRowPostileMaps

protected java.util.Map[] columnRowPostileMaps

ex_tool

protected ExcelHiddenCellsTool ex_tool

totalBreak

protected int totalBreak

sheets2Export

protected int[] sheets2Export

构造器详细资料

AbstractExcelExporter

public AbstractExcelExporter()

方法详细资料

export

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

导出Workbook

参数:

out - 输出流

workbook - 结果报表

抛出:

java.lang.Exception

getFormat

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

createFont

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

getRotation

protected abstract short getRotation(Style style)

getFloatLeftMax

protected abstract int getFloatLeftMax(double columnWidth)

getFloatTopMax

protected abstract int getFloatTopMax(double rowHeight)

setSheets2Export

public void setSheets2Export(int[] sheets)

checkValueVertical

protected java.lang.Object checkValueVertical(java.lang.Object value,
                                  Style style,
                                  int width,
                                  int height)

isShowAsImage

protected boolean isShowAsImage(int textStyle,
                    CellGUIAttr cellGUIAttr)

dealWithHiddenCR

protected int[] dealWithHiddenCR(int start,
                     int span,
                     IntList hiddenList)

dealWithSumFormula

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

checkNumberFormat

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

setAttr4ECReportSIL

protected void setAttr4ECReportSIL(Calculator cal,
                       IntList hiddenRowList,
                       IntList hiddenColList,
                       ElementCase report)

setPostilMap

public void setPostilMap(java.util.Map[] columnRowPostileMaps)

设置标识错误的单元格

参数:

columnRowPostileMaps - 标识错误的单元格组成的map

dealWithFormula

protected void dealWithFormula(POICellAction poiCell,
                   java.lang.String contentFormula)

导出保留公式

参数:

poiCell - 当前处理的poi单元格

contentFormula - 当前格子设置的公式内容

getPassword

protected java.lang.String getPassword(ResultWorkBook book)

获取报表中设置的Excel导出保护工作表密码

参数:

book - 当前导出的结果报表

setSheetName

protected void setSheetName(POIWorkbookAction wb,
                java.lang.String name4Sheet)

设置Excelsheet的名字, 同时避免在Workbook中出现重命名现象 限定长度为31个字符

参数:

wb - 当前的Excel Book

name4Sheet - 指定的sheet名

dealWithPrintSetUp

protected void dealWithPrintSetUp(POIPrintSetupAction printSetup,
                      PaperSize paperSize,
                      int orientation,
                      ReportSettingsProvider reportSettings)

导出当前报表的打印设置到excel, 包括纸张, 横纵向, 页眉页脚距离

参数:

printSetup - excel中的打印设置

paperSize - 报表中的纸张设置

orientation - 横纵向显示

reportSettings - 报表页面设置

dealWithAlignAndMargin

protected void dealWithAlignAndMargin(POISheetAction sheet,
                          ReportSettingsProvider reportSettings,
                          Margin margin)

设置是否垂直水平居中, 以及边距

参数:

sheet - 导出的poisheet

reportSettings - 报表页面设置

margin - 边距

dealWithBufferImage

protected void dealWithBufferImage(java.lang.Object value,
                       POIClientAnchorAction clientAnchor,
                       POIPatriarchAction patriarch,
                       Style style,
                       int width,
                       int height,
                       java.awt.image.BufferedImage buffImg,
                       POIWorkbookAction wb)

将BufferImage转化成excel中的悬浮元素

参数:

value - 当前悬浮元素

clientAnchor - excel中定位元素

patriarch - excel中的悬浮元素

style - 悬浮元素样式

width - 悬浮元素宽度

height - 悬浮元素高度

buffImg - 待转化的BufferImage

wb - 当前excel工作表

createSimpleFont

protected POIFontAction createSimpleFont(POIWorkbookAction wb,
                             AbstractExcelExporter.FontAdapter font,
                             POIFontAction fontWrapper,
                             java.lang.String cellFontName)

获取当前字体的样式, 并加以缓存

参数:

wb - 导出的excel workbook

font - 字体适配器

fontWrapper - excel中的字体

createComplexFont4FR

protected void createComplexFont4FR(FRFont frFont,
                        POIFontAction font)

复杂点的字体设置, java原生的不带, 字体上下标, 下划线等

参数:

frFont - 报表里的font

font - excel中的font

executeCellStyle

protected void executeCellStyle(POIWorkbookAction wb,
                    POICellStyleAction hssfCellStyle,
                    Style style)

将报表中的单元格样式设置到excel单元格中

参数:

wb - excel报表

hssfCellStyle - excel格子样式

style - 报表格子样式

getMapBorder

protected short getMapBorder(int border)

根据报表设置的边框线返回Excel对应的线型

参数:

border - 报表边框线线型

loadPicture

protected int loadPicture(java.awt.image.BufferedImage bufferedImage,
              POIWorkbookAction wb)
                   throws java.io.IOException

抛出:

java.io.IOException

applyReportHFHeader

protected void applyReportHFHeader(ReportHFProvider reportHF,
                       POIHeaderFooterAction header)

设置页眉

参数:

reportHF - 报表的页眉页脚

header - 当前excel sheet的页眉

applyReportHFFooter

protected void applyReportHFFooter(ReportHFProvider reportHF,
                       POIHeaderFooterAction footer)

设置页脚

参数:

reportHF - 报表的页眉页脚

footer - 当前excel sheet的页脚

checkInvalidFormula

protected boolean checkInvalidFormula(java.lang.String formulaText)

用FRParser来判断公式是否合法

参数:

formulaText - 公式内容

setDefaultFont

protected void setDefaultFont(POIWorkbookAction hssfWorkbook)

设置导出默认字体

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

将报表导出成excel

参数:

book - 结果报表

workbookWrapper - 导出的excel表

cellList - 单元格列表

cellFormulaList - 单元格保留公式列表

reportList - 报表集合

reUse - 是否可以重用

抛出:

java.lang.Exception

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,
              int[] sheets)
                   throws java.lang.Exception

将报表导出成excel

参数:

book - 结果报表

workbookWrapper - 导出的excel表

cellList - 单元格列表

cellFormulaList - 单元格保留公式列表

reportList - 报表集合

reUse - 是否可以重用

sheets - 导出的sheet序号

抛出:

java.lang.Exception

adjustProperFontSize

protected Style adjustProperFontSize(Style style)

调整下当前格子导出的字体大小

参数:

style - 当前格子样式

innerExportReports

protected abstract void innerExportReports(ResultECReport innerReport,
                      ResultWorkBook book,
                      POIWorkbookAction workbook,
                      java.util.List cellList,
                      java.util.List<java.lang.String> cellFormulaList,
                      java.util.List<Report> reportList,
                      int index)

replaceNewLineChar

protected java.lang.String replaceNewLineChar(java.lang.String allString)

peter:替换成newline

locateFloatElementInExcel

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

定位excel中悬浮元素的位置

参数:

floatElement - 报表中的悬浮元素

rowHeightList - 报表行高集合

columnWidthList - 报表列宽集合

report - 当前报表

value - 当前格子的值

setColumnRowBreak

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

设置Excel中的行列分页点

参数:

cellElement - 当前单元格

sheet - 当前报表sheet

column - 当前列

row - 当前行

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

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

html2HSSFRichTextString

protected POIRichStringAction html2HSSFRichTextString(POIWorkbookAction wb,
                                          java.lang.String html,
                                          Style style)
                                               throws java.lang.Exception

抛出:

java.lang.Exception

evalHtmlContent

protected java.lang.Object evalHtmlContent(POIWorkbookAction wb,
                               java.lang.Object value,
                               Style style,
                               int width,
                               int height)

initRichString

protected abstract POIRichStringAction initRichString(java.lang.String content)

evalFormulaValue

protected java.lang.Object evalFormulaValue(java.lang.Object value,
                                boolean exHiddenRow,
                                boolean exHiddenColumn,
                                java.util.List cellList,
                                POICellAction cell,
                                Calculator cal,
                                java.util.List cellFormulaContentList)

重新计算存在公式的单元格的值

参数:

value - 公式

exHiddenRow - 是否隐藏行

exHiddenColumn - 是否隐藏列

cellList - 保存含有公式的单元格列表

cell - 单元格

cal - cal

cellFormulaContentList - 单元格公式重新依据单元格导出的位置计算过后的公式内容

返回:

单元格值

evalCellValue

protected 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)