Package | Description |
---|---|
org.apache.poi.hssf.usermodel |
The usermodel package maps HSSF low level structures to familiar workbook/sheet model
|
org.apache.poi.ss.formula |
This package contains common internal POI code for manipulating formulas.
|
org.apache.poi.ss.formula.ptg |
The formula package contains binary PTG structures used in Formulas
|
org.apache.poi.ss.usermodel | |
org.apache.poi.ss.util | |
org.apache.poi.xssf.streaming | |
org.apache.poi.xssf.usermodel |
Modifier and Type | Method and Description |
---|---|
AreaReference |
HSSFCreationHelper.createAreaReference(CellReference topLeft,
CellReference bottomRight)
Creates an area ref from a pair of Cell References..
|
AreaReference |
HSSFCreationHelper.createAreaReference(java.lang.String reference)
Creates an AreaReference.
|
Modifier and Type | Method and Description |
---|---|
Ptg |
HSSFEvaluationWorkbook.get3DReferencePtg(AreaReference areaRef,
SheetIdentifier sheet) |
Modifier and Type | Method and Description |
---|---|
Ptg |
FormulaParsingWorkbook.get3DReferencePtg(AreaReference area,
SheetIdentifier sheet)
Produce the appropriate Ptg for a 3d area reference
|
Constructor and Description |
---|
Area2DPtgBase(AreaReference ar) |
Area3DPtg(AreaReference arearef,
int externIdx) |
Area3DPxg(int externalWorkbookNumber,
SheetIdentifier sheetName,
AreaReference arearef) |
Area3DPxg(SheetIdentifier sheetName,
AreaReference arearef) |
AreaPtg(AreaReference arearef) |
AreaPtgBase(AreaReference ar) |
Modifier and Type | Method and Description |
---|---|
AreaReference |
CreationHelper.createAreaReference(CellReference topLeft,
CellReference bottomRight)
Creates an area ref from a pair of Cell References..
|
AreaReference |
CreationHelper.createAreaReference(java.lang.String reference)
Creates an AreaReference.
|
Modifier and Type | Method and Description |
---|---|
static AreaReference[] |
AreaReference.generateContiguous(SpreadsheetVersion version,
java.lang.String reference)
Takes a non-contiguous area reference, and returns an array of contiguous area references
|
static AreaReference |
AreaReference.getWholeColumn(SpreadsheetVersion version,
java.lang.String start,
java.lang.String end)
Construct an AreaReference which spans one more columns.
|
static AreaReference |
AreaReference.getWholeRow(SpreadsheetVersion version,
java.lang.String start,
java.lang.String end)
Construct an AreaReference which spans one more rows
|
Modifier and Type | Method and Description |
---|---|
AreaReference |
SXSSFCreationHelper.createAreaReference(CellReference topLeft,
CellReference bottomRight)
Creates an area ref from a pair of Cell References..
|
AreaReference |
SXSSFCreationHelper.createAreaReference(java.lang.String reference)
Creates an AreaReference.
|
Modifier and Type | Method and Description |
---|---|
AreaReference |
XSSFCreationHelper.createAreaReference(CellReference topLeft,
CellReference bottomRight)
Creates an area ref from a pair of Cell References..
|
AreaReference |
XSSFCreationHelper.createAreaReference(java.lang.String reference)
Creates an AreaReference.
|
AreaReference |
XSSFTable.getArea()
Get the area that this table covers.
|
AreaReference |
XSSFTable.getCellReferences()
Get the area reference for the cells which this table covers.
|
protected AreaReference |
XSSFPivotTable.getPivotArea() |
AreaReference |
XSSFPivotCacheDefinition.getPivotArea(Workbook wb)
Find the 2D base data area for the pivot table, either from its direct reference or named table/range.
|
Modifier and Type | Method and Description |
---|---|
XSSFPivotTable |
XSSFSheet.createPivotTable(AreaReference source,
CellReference position)
Create a pivot table using the AreaReference range, at the given position.
|
XSSFPivotTable |
XSSFSheet.createPivotTable(AreaReference source,
CellReference position,
Sheet sourceSheet)
Create a pivot table using the AreaReference range on sourceSheet, at the given position.
|
XSSFTable |
XSSFSheet.createTable(AreaReference tableArea)
Creates a new Table, and associates it with this Sheet.
|
Ptg |
BaseXSSFEvaluationWorkbook.get3DReferencePtg(AreaReference area,
SheetIdentifier sheet) |
void |
XSSFTable.setArea(AreaReference tableArea)
Set the area reference for the cells which this table covers.
|
protected void |
XSSFTable.setCellRef(AreaReference refs) |
void |
XSSFTable.setCellReferences(AreaReference refs)
Set the area reference for the cells which this table covers.
|
Copyright 2022 The Apache Software Foundation or its licensors, as applicable.