| 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 |
| 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(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(String reference)
Creates an AreaReference.
|
| Modifier and Type | Method and Description |
|---|---|
static AreaReference[] |
AreaReference.generateContiguous(SpreadsheetVersion version,
String reference)
Takes a non-contiguous area reference, and returns an array of contiguous area references
|
static AreaReference |
AreaReference.getWholeColumn(SpreadsheetVersion version,
String start,
String end)
Construct an AreaReference which spans one more columns.
|
static AreaReference |
AreaReference.getWholeRow(SpreadsheetVersion version,
String start,
String end)
Construct an AreaReference which spans one more rows
|