public class XSSFPivotTable
extends org.apache.poi.ooxml.POIXMLDocumentPart
Modifier and Type | Method and Description |
---|---|
void |
addColLabel(int columnIndex)
Add a col label using data from the given column.
|
void |
addColLabel(int columnIndex,
String valueFormat)
Add a col label using data from the given column.
|
void |
addColumnLabel(DataConsolidateFunction function,
int columnIndex)
Add a column label using data from the given column and specified function
|
void |
addColumnLabel(DataConsolidateFunction function,
int columnIndex,
String valueFieldName)
Add a column label using data from the given column and specified function
|
void |
addColumnLabel(DataConsolidateFunction function,
int columnIndex,
String valueFieldName,
String valueFormat)
Add a column label using data from the given column and specified function
|
void |
addDataColumn(int columnIndex,
boolean isDataField)
Add column containing data from the referenced area.
|
void |
addReportFilter(int columnIndex)
Add filter for the column with the corresponding index and cell value
|
void |
addRowLabel(int columnIndex)
Add a row label using data from the given column.
|
List<Integer> |
getColLabelColumns() |
CTPivotTableDefinition |
getCTPivotTableDefinition() |
Sheet |
getDataSheet() |
Sheet |
getParentSheet() |
XSSFPivotCache |
getPivotCache() |
XSSFPivotCacheDefinition |
getPivotCacheDefinition() |
XSSFPivotCacheRecords |
getPivotCacheRecords() |
List<Integer> |
getRowLabelColumns() |
void |
readFrom(InputStream is) |
void |
setCTPivotTableDefinition(CTPivotTableDefinition pivotTableDefinition) |
void |
setParentSheet(XSSFSheet parentSheet) |
void |
setPivotCache(XSSFPivotCache pivotCache) |
void |
setPivotCacheDefinition(XSSFPivotCacheDefinition pivotCacheDefinition) |
void |
setPivotCacheRecords(XSSFPivotCacheRecords pivotCacheRecords) |
_invokeOnDocumentRead, addRelation, createRelationship, createRelationship, createRelationship, getPackagePart, getParent, getRelationById, getRelationId, getRelationPartById, getRelationParts, getRelations, isCommited, isCommitted, setCommited, setCommitted, toString
@Beta public void readFrom(InputStream is) throws IOException
IOException
@Beta public void setPivotCache(XSSFPivotCache pivotCache)
@Beta public XSSFPivotCache getPivotCache()
@Beta @Internal public CTPivotTableDefinition getCTPivotTableDefinition()
@Beta @Internal public void setCTPivotTableDefinition(CTPivotTableDefinition pivotTableDefinition)
@Beta public XSSFPivotCacheDefinition getPivotCacheDefinition()
@Beta public void setPivotCacheDefinition(XSSFPivotCacheDefinition pivotCacheDefinition)
@Beta public XSSFPivotCacheRecords getPivotCacheRecords()
@Beta public void setPivotCacheRecords(XSSFPivotCacheRecords pivotCacheRecords)
@Beta public void addRowLabel(int columnIndex)
columnIndex
- the index of the source column to be used as row label.
columnIndex
is 0-based indexed and relative to the first column in the source.@Beta public void addColLabel(int columnIndex, String valueFormat)
columnIndex
- the index of the source column to be used as row label.
columnIndex
is 0-based indexed and relative to the first column in the source.valueFormat
- format of column value (e.g. for date: "DD.MM.YYYY")@Beta public void addColLabel(int columnIndex)
columnIndex
- the index of the source column to be used as row label.
columnIndex
is 0-based indexed and relative to the first column in the source.@Beta public void addColumnLabel(DataConsolidateFunction function, int columnIndex, String valueFieldName, String valueFormat)
columnIndex
- the index of the source column to be used as column label.
columnIndex
is 0-based indexed and relative to the first column in the source.function
- the function to be used on the data
The following functions exists:
Sum, Count, Average, Max, Min, Product, Count numbers, StdDev, StdDevp, Var, VarpvalueFieldName
- the name of pivot table value fieldvalueFormat
- format of value field (e.g. "#,##0.00")@Beta public void addColumnLabel(DataConsolidateFunction function, int columnIndex, String valueFieldName)
columnIndex
- the index of the source column to be used as column label.
columnIndex
is 0-based indexed and relative to the first column in the source.function
- the function to be used on the data
The following functions exists:
Sum, Count, Average, Max, Min, Product, Count numbers, StdDev, StdDevp, Var, VarpvalueFieldName
- the name of pivot table value field@Beta public void addColumnLabel(DataConsolidateFunction function, int columnIndex)
columnIndex
- the index of the source column to be used as column label
columnIndex
is 0-based indexed and relative to the first column in the source..function
- the function to be used on the data
The following functions exists:
Sum, Count, Average, Max, Min, Product, Count numbers, StdDev, StdDevp, Var, Varp@Beta public void addDataColumn(int columnIndex, boolean isDataField)
columnIndex
- the index of the column containing the dataisDataField
- true if the data should be displayed in the pivot table.@Beta public void addReportFilter(int columnIndex)
columnIndex
- index of column to filter onCopyright © 2010 - 2020 Adobe. All Rights Reserved