Package | Description |
---|---|
org.apache.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.apache.poi.hssf.util |
util package contains tools needed for writing HSSF files that are not necesarily "real"
HSSF concepts.
|
org.apache.poi.ss.formula |
This package contains common internal POI code for manipulating formulas.
|
org.apache.poi.ss.formula.ptg |
formula package contains binary PTG structures used in Formulas
|
org.apache.poi.ss.util | |
org.apache.poi.xssf.usermodel |
Modifier and Type | Method | Description |
---|---|---|
Ptg |
HSSFEvaluationWorkbook.get3DReferencePtg(AreaReference areaRef,
SheetIdentifier sheet) |
Modifier and Type | Class | Description |
---|---|---|
class |
AreaReference |
Modifier and Type | Method | Description |
---|---|---|
Ptg |
FormulaParsingWorkbook.get3DReferencePtg(AreaReference area,
SheetIdentifier sheet) |
Produce the appropriate Ptg for a 3d area reference
|
Constructor | 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 | Description |
---|---|---|
static AreaReference[] |
AreaReference.generateContiguous(java.lang.String reference) |
Takes a non-contiguous area reference, and
returns an array of contiguous area references.
|
static AreaReference |
AreaReference.getWholeColumn(java.lang.String start,
java.lang.String end) |
|
static AreaReference |
AreaReference.getWholeRow(java.lang.String start,
java.lang.String end) |
Modifier and Type | Method | Description |
---|---|---|
protected AreaReference |
XSSFPivotTable.getPivotArea() |
Modifier and Type | Method | Description |
---|---|---|
XSSFPivotTable |
XSSFSheet.createPivotTable(AreaReference source,
CellReference position) |
Create a pivot table and set area of source and a position for pivot table
|
XSSFPivotTable |
XSSFSheet.createPivotTable(AreaReference source,
CellReference position,
Sheet sourceSheet) |
Create a pivot table and set area of source, source sheet and a position for pivot table
|
protected void |
XSSFPivotTable.createSourceReferences(AreaReference source,
CellReference position,
Sheet sourceSheet) |
Creates cacheSource and workSheetSource for pivot table and sets the source reference as well assets the location of the pivot table
|
Ptg |
XSSFEvaluationWorkbook.get3DReferencePtg(AreaReference area,
SheetIdentifier sheet) |
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.