public class PageExcelExporter extends ExcelExporter
AbstractExcelExporter.FontAdapter, AbstractExcelExporter.JavaFontAdapter, AbstractExcelExporter.TextFontAdapterisExcel2003A3_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, setVersionadjustProperFontSize, 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, setSheets2Exportexport, exportpublic void export(java.io.OutputStream out,
ResultWorkBook book)
throws java.lang.Exception
export 在接口中 AppExporter<java.lang.Boolean>export 在类中 ExcelExporterout - 输出流book - 结果报表java.lang.Exception - 导出失败则抛出此异常public void export(java.io.OutputStream out,
ResultWorkBook book,
boolean reUse)
throws java.lang.Exception
export 在类中 ExcelExporterout - 输出流book - 结果报表reUse - 是否可重用java.lang.Exceptionprotected AppExporter getExporterFor2007(java.util.List<PaperSettingProvider> paperSettingList) throws java.lang.ClassNotFoundException
ExcelExportergetExporterFor2007 在类中 ExcelExporterjava.lang.ClassNotFoundExceptionprotected 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
AbstractExcelExporterexportBook 在类中 AbstractExcelExporter<java.lang.Boolean>book - 结果报表workbookWrapper - 导出的excel表cellList - 单元格列表cellFormulaList - 单元格保留公式列表reportList - 报表集合reUse - 是否可以重用java.lang.Exception