接口 com.fr.io.exporter.poi.wrapper.POIWorkbookAction
的使用

使用POIWorkbookAction的程序包

程序包	说明
com.fr.io.exporter
com.fr.io.exporter.excel.stream
com.fr.io.exporter.poi.wrapper
com.fr.web.core.utils

com.fr.io.exporter中POIWorkbookAction的使用

参数类型为POIWorkbookAction的com.fr.io.exporter中的方法

限定符和类型	方法和说明
protected POIFontAction	ExcelExporter.createFont(POIWorkbookAction wbWrapper, java.awt.Font font)
protected abstract POIFontAction	AbstractExcelExporter.createFont(POIWorkbookAction wbWrapper, java.awt.Font font)
protected POIFontAction	AbstractExcelExporter.createSimpleFont(POIWorkbookAction wb, AbstractExcelExporter.FontAdapter font, POIFontAction fontWrapper, java.lang.String cellFontName) 获取当前字体的样式, 并加以缓存
protected void	AbstractExcelExporter.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 java.lang.Object	AbstractExcelExporter.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	AbstractExcelExporter.evalHtmlContent(POIWorkbookAction wb, java.lang.Object value, Style style, int width, int height)
protected void	AbstractExcelExporter.executeCellStyle(POIWorkbookAction wb, POICellStyleAction hssfCellStyle, Style style) 将报表中的单元格样式设置到excel单元格中
protected void	PageToSheetExcelExporter.exportBook(ResultWorkBook book, POIWorkbookAction workbookWrapper, java.util.List cellList, java.util.List<java.lang.String> cellFormulaList, java.util.List<Report> reportList, boolean reUse)
protected void	PageToSheetExcel2007Exporter.exportBook(ResultWorkBook book, POIWorkbookAction workbookWrapper, java.util.List cellList, java.util.List<java.lang.String> cellFormulaList, java.util.List<Report> reportList, boolean reUse)
protected void	PageExcelExporter.exportBook(ResultWorkBook book, POIWorkbookAction workbookWrapper, java.util.List cellList, java.util.List<java.lang.String> cellFormulaList, java.util.List<Report> reportList, boolean reUse)
protected void	PageExcel2007Exporter.exportBook(ResultWorkBook book, POIWorkbookAction workbookWrapper, java.util.List cellList, java.util.List<java.lang.String> cellFormulaList, java.util.List<Report> reportList, boolean reUse)
protected void	LargeDataPageExcelExporter.exportBook(ResultWorkBook book, POIWorkbookAction workbookWrapper, java.util.List cellList, java.util.List<java.lang.String> cellFormulaList, java.util.List<Report> reportList, boolean reUse)
protected void	AbstractExcelExporter.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	AbstractExcelExporter.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 short	ExcelExporter.getFormat(POIWorkbookAction wb, java.lang.String pattern)
protected abstract short	AbstractExcelExporter.getFormat(POIWorkbookAction wb, java.lang.String pattern)
protected POIRichStringAction	AbstractExcelExporter.html2HSSFRichTextString(POIWorkbookAction wb, java.lang.String html, Style style)
protected void	ExcelExporter.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)
protected abstract void	AbstractExcelExporter.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 int	AbstractExcelExporter.loadPicture(java.awt.image.BufferedImage bufferedImage, POIWorkbookAction wb)
protected void	AbstractExcelExporter.setDefaultFont(POIWorkbookAction hssfWorkbook) 设置导出默认字体
protected void	AbstractExcelExporter.setSheetName(POIWorkbookAction wb, java.lang.String name4Sheet) 设置Excelsheet的名字, 同时避免在Workbook中出现重命名现象 限定长度为31个字符

com.fr.io.exporter.excel.stream中POIWorkbookAction的使用

参数类型为POIWorkbookAction的com.fr.io.exporter.excel.stream中的方法

限定符和类型	方法和说明
POIFontAction	StreamExcel2007Exporter.createFont(POIWorkbookAction wbWrapper, java.awt.Font font)
java.lang.Object	StreamExcel2007Exporter.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 short	StreamExcel2007Exporter.getFormat(POIWorkbookAction wb, java.lang.String pattern)
protected void	StreamExcel2007Exporter.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)

com.fr.io.exporter.poi.wrapper中POIWorkbookAction的使用

实现POIWorkbookAction的com.fr.io.exporter.poi.wrapper中的类

限定符和类型	类和说明
class	HssfWorkbookWrapper
class	XssfWorkbookWrapper

com.fr.web.core.utils中POIWorkbookAction的使用

参数类型为POIWorkbookAction的com.fr.web.core.utils中的方法

限定符和类型	方法和说明
static void	ExportUtils.dealWithBufferImage(java.lang.Object value, POIClientAnchorAction clientAnchor, POIPatriarchAction patriarch, java.awt.image.BufferedImage buffImg, POIWorkbookAction wb) 将BufferImage转化成excel中的悬浮元素
static int	ExportUtils.loadPicture(java.awt.image.BufferedImage bufferedImage, POIWorkbookAction wb)
static void	ExportUtils.setSheetName(POIWorkbookAction wb, java.lang.String name4Sheet) 设置Excelsheet的名字, 同时避免在Workbook中出现重命名现象 限定长度为31个字符