org.nuxeo.ecm.platform.groups.audit.service.acl.excel

Class ExcelBuilderMultiSheet

java.lang.Object

org.nuxeo.ecm.platform.groups.audit.service.acl.excel.ExcelBuilder

org.nuxeo.ecm.platform.groups.audit.service.acl.excel.ExcelBuilderMultiSheet

All Implemented Interfaces:

IExcelBuilder

public class ExcelBuilderMultiSheet
extends ExcelBuilder

Override the default ExcelBuilder to write over several excel sheet once a cell column exceeds the maximum number of column for excel.

Author:

Martin Pernollet

Nested Class Summary

Nested classes/interfaces inherited from class org.nuxeo.ecm.platform.groups.audit.service.acl.excel.ExcelBuilder

ExcelBuilder.Type

Field Summary

Fields inherited from class org.nuxeo.ecm.platform.groups.audit.service.acl.excel.ExcelBuilder

CRASH_ON_CELL_OVERFLOW, LAST_COLUMN, LAST_ROW, MAX_COLUMN, MAX_ROW

Constructor Summary

Constructors

Constructor and Description
ExcelBuilderMultiSheet()
ExcelBuilderMultiSheet(ExcelBuilder.Type type)
ExcelBuilderMultiSheet(ExcelBuilder.Type type, String firstSheet)

Method Summary

Methods

Modifier and Type	Method and Description
int	getVirtualCellColumn(int realColumn) Return a column ID for the expected cell: returns 255 for realColumn=255 returns 0 for realColumn=256 ...
int	getVirtualCellSheet(int realColumn) Return a sheet ID for the expected cell: sheet 0 for cells [0;255] sheet 1 for cells [256;511] ...
boolean	isMultiSheetColumns()
void	setMultiSheetColumns(boolean multiSheetMode) If true, the builder is able to switch on next sheets to fill cells with column id > 255.

Methods inherited from class org.nuxeo.ecm.platform.groups.audit.service.acl.excel.ExcelBuilder

addComment, buildComment, getAllSheets, getBoldFont, getColor, getColor, getCurrentSheet, getCurrentSheetId, getHSSFWorkbook, getWorkbook, load, load, loadPicture, mergeRange, newCellStyle, newColoredCellStyle, newFont, newFont, newSheet, save, save, setCell, setCell, setColumnWidth, setColumnWidthAuto, setCurrentSheetId, setFreezePane, setFreezePane, setPicture, setRowHeight, setSplitPane

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelBuilderMultiSheet

public ExcelBuilderMultiSheet()

ExcelBuilderMultiSheet

public ExcelBuilderMultiSheet(ExcelBuilder.Type type,
                      String firstSheet)

ExcelBuilderMultiSheet

public ExcelBuilderMultiSheet(ExcelBuilder.Type type)

Method Detail

isMultiSheetColumns

public boolean isMultiSheetColumns()

setMultiSheetColumns

public void setMultiSheetColumns(boolean multiSheetMode)

If true, the builder is able to switch on next sheets to fill cells with column id > 255.

getVirtualCellSheet

public int getVirtualCellSheet(int realColumn)

Return a sheet ID for the expected cell:

• sheet 0 for cells [0;255]
• sheet 1 for cells [256;511]
• ...

getVirtualCellColumn

public int getVirtualCellColumn(int realColumn)

Return a column ID for the expected cell:

• returns 255 for realColumn=255
• returns 0 for realColumn=256
• ...