Package | Description |
---|---|
org.zkoss.poi.hssf.record.aggregates |
record aggregates are not real "records" but collections of records that act as a single record.
|
org.zkoss.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.zkoss.poi.hssf.util |
util package contains tools needed for writing HSSF files that are not necesarily "real"
HSSF concepts.
|
org.zkoss.poi.ss.formula |
This package contains common internal POI code for manipulating formulas.
|
org.zkoss.poi.ss.formula.ptg |
formula package contains binary PTG structures used in Formulas
|
org.zkoss.poi.ss.usermodel | |
org.zkoss.poi.ss.util | |
org.zkoss.poi.xssf.streaming | |
org.zkoss.poi.xssf.usermodel | |
org.zkoss.poi.xssf.usermodel.helpers | |
org.zkoss.zpoiex.ss.usermodel.helpers |
Modifier and Type | Method and Description |
---|---|
static SharedValueManager |
SharedValueManager.create(SharedFormulaRecord[] sharedFormulaRecords,
CellReference[] firstCells,
ArrayRecord[] arrayRecords,
TableRecord[] tableRecords) |
SharedFormulaRecord |
SharedValueManager.linkSharedFormulaRecord(CellReference firstCell,
FormulaRecordAggregate agg) |
Modifier and Type | Method and Description |
---|---|
PivotTable |
HSSFSheet.createPivotTable(CellReference destination,
String name,
PivotCache pivotCache) |
Modifier and Type | Class and Description |
---|---|
class |
CellReference
Common conversion functions between Excel style A1, C27 style
cell references, and POI usermodel style row=0, column=0
style references.
|
Modifier and Type | Method and Description |
---|---|
CellReference |
Formula.getExpReference()
Gets the locator for the corresponding
SharedFormulaRecord ,
ArrayRecord or TableRecord
if this formula belongs to such a grouping. |
Constructor and Description |
---|
Ref3DPtg(CellReference c,
int externIdx) |
RefPtg(CellReference cr) |
RefPtgBase(CellReference c) |
Modifier and Type | Method and Description |
---|---|
CellReference |
PivotTable.getFirstDataRef()
Returns the first data
CellReference |
Modifier and Type | Method and Description |
---|---|
PivotTable |
Sheet.createPivotTable(CellReference destination,
String name,
PivotCache pivotCache) |
PivotTable |
PivotTableHelper.createPivotTable(CellReference destination,
String name,
PivotCache pivotCache,
Sheet sheet) |
Modifier and Type | Method and Description |
---|---|
CellReference[] |
AreaReference.getAllReferencedCells()
Returns a reference to every cell covered by this area
|
CellReference |
AreaReference.getFirstCell() |
CellReference |
AreaReference.getLastCell()
Note - if this area reference refers to a single cell, the return value of this method will
be identical to that of getFirstCell()
|
Modifier and Type | Method and Description |
---|---|
static boolean |
AreaReference.isWholeColumnReference(SpreadsheetVersion version,
CellReference topLeft,
CellReference botRight)
Is the reference for a whole-column reference,
such as C:C or D:G ?
|
static boolean |
AreaReference.isWholeRowReference(SpreadsheetVersion version,
CellReference topLeft,
CellReference botRight) |
Constructor and Description |
---|
AreaReference(CellReference topLeft,
CellReference botRight)
Creates an area ref from a pair of Cell References.
|
Modifier and Type | Method and Description |
---|---|
PivotTable |
SXSSFSheet.createPivotTable(CellReference destination,
String name,
PivotCache pivotCache) |
Modifier and Type | Method and Description |
---|---|
CellReference |
XSSFTable.getEndCellReference() |
CellReference |
XSSFPivotTable.getFirstDataRef() |
CellReference |
XSSFTable.getStartCellReference() |
Modifier and Type | Method and Description |
---|---|
PivotTable |
XSSFSheet.createPivotTable(CellReference destination,
String name,
PivotCache pivotCache) |
Modifier and Type | Method and Description |
---|---|
PivotTable |
XSSFPivotTableHelper.createPivotTable(CellReference destination,
String name,
PivotCache pivotCache,
Sheet sheet) |
Modifier and Type | Method and Description |
---|---|
PivotTable |
PivotTableHelper.createPivotTable(CellReference destination,
String name,
PivotCache pivotCache,
Sheet sheet) |
Copyright © 2020. All rights reserved.