public class PageExcelExporter extends ExcelExporter
AbstractExcelExporter.FontAdapter, AbstractExcelExporter.JavaFontAdapter, AbstractExcelExporter.TextFontAdapter
isExcel2003
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
构造器和说明 |
---|
PageExcelExporter(java.util.List paperSettingList) |
限定符和类型 | 方法和说明 |
---|---|
void |
export(java.io.OutputStream out,
ResultWorkBook book)
分页导出Excel
分页导出excel的例子:
PageRWorkBook book = (PageRWorkBook) workbook.execute(new HashMap(), ActorFactory.getActor("page"));
PageExcelExporter page = new PageExcelExporter(ReportUtils.getPaperSettingListFromWorkBook(book));
OutputStream os = new FileOutputStream(new File("c:/a.xls"));
page.export(os, book);
|
void |
export(java.io.OutputStream out,
ResultWorkBook book,
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)
将报表导出成excel
|
protected AppExporter |
getExporterFor2007(java.util.List<PaperSettingProvider> paperSettingList)
获取当前类对应的excel 2007导出类
|
checkExcelExportVersion, createFont, dealECReportAndBlockPageSetting, dealWithPageSetting, export, export, exportFor2003, exportFor2007, getFloatLeftMax, getFloatTopMax, getFormat, getRotation, initRichString, innerExportReport, innerExportReports, isExcel2003, setVersion
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
export, export
public void export(java.io.OutputStream out, ResultWorkBook book) throws java.lang.Exception
export
在接口中 AppExporter<java.lang.Boolean>
export
在类中 ExcelExporter
out
- 输出流book
- 结果报表java.lang.Exception
- 导出失败则抛出此异常public void export(java.io.OutputStream out, ResultWorkBook book, boolean reUse) throws java.lang.Exception
export
在类中 ExcelExporter
out
- 输出流book
- 结果报表reUse
- 是否可重用java.lang.Exception
protected AppExporter getExporterFor2007(java.util.List<PaperSettingProvider> paperSettingList) throws java.lang.ClassNotFoundException
ExcelExporter
getExporterFor2007
在类中 ExcelExporter
java.lang.ClassNotFoundException
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
exportBook
在类中 AbstractExcelExporter<java.lang.Boolean>
book
- 结果报表workbookWrapper
- 导出的excel表cellList
- 单元格列表cellFormulaList
- 单元格保留公式列表reportList
- 报表集合reUse
- 是否可以重用java.lang.Exception