org.apache.poi.xssf.usermodel

Class XSSFPivotTable

java.lang.Object

org.apache.poi.POIXMLDocumentPart

org.apache.poi.xssf.usermodel.XSSFPivotTable

public class XSSFPivotTable
extends POIXMLDocumentPart

Field Summary

Fields inherited from class org.apache.poi.POIXMLDocumentPart

DEFAULT_XML_OPTIONS

Method Summary

Modifier and Type	Method and Description
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, java.lang.String valueFieldName) 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.
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPivotTableDefinition	getCTPivotTableDefinition()
Sheet	getDataSheet()
Sheet	getParentSheet()
XSSFPivotCache	getPivotCache()
XSSFPivotCacheDefinition	getPivotCacheDefinition()
XSSFPivotCacheRecords	getPivotCacheRecords()
java.util.List<java.lang.Integer>	getRowLabelColumns()
void	readFrom(java.io.InputStream is)
void	setCTPivotTableDefinition(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPivotTableDefinition pivotTableDefinition)
void	setParentSheet(XSSFSheet parentSheet)
void	setPivotCache(XSSFPivotCache pivotCache)
void	setPivotCacheDefinition(XSSFPivotCacheDefinition pivotCacheDefinition)
void	setPivotCacheRecords(XSSFPivotCacheRecords pivotCacheRecords)

Methods inherited from class org.apache.poi.POIXMLDocumentPart

addRelation, createRelationship, createRelationship, getPackagePart, getPackageRelationship, getParent, getRelationById, getRelationId, getRelations, toString

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Method Detail

readFrom

@Beta
public void readFrom(java.io.InputStream is)
                    throws java.io.IOException

Throws:

java.io.IOException

setPivotCache

@Beta
public void setPivotCache(XSSFPivotCache pivotCache)

getPivotCache

@Beta
public XSSFPivotCache getPivotCache()

getParentSheet

@Beta
public Sheet getParentSheet()

setParentSheet

@Beta
public void setParentSheet(XSSFSheet parentSheet)

getCTPivotTableDefinition

@Beta
 @Internal
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPivotTableDefinition getCTPivotTableDefinition()

setCTPivotTableDefinition

@Beta
 @Internal
public void setCTPivotTableDefinition(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPivotTableDefinition pivotTableDefinition)

getPivotCacheDefinition

@Beta
public XSSFPivotCacheDefinition getPivotCacheDefinition()

setPivotCacheDefinition

@Beta
public void setPivotCacheDefinition(XSSFPivotCacheDefinition pivotCacheDefinition)

getPivotCacheRecords

@Beta
public XSSFPivotCacheRecords getPivotCacheRecords()

setPivotCacheRecords

@Beta
public void setPivotCacheRecords(XSSFPivotCacheRecords pivotCacheRecords)

getDataSheet

@Beta
public Sheet getDataSheet()

addRowLabel

@Beta
public void addRowLabel(int columnIndex)

Add a row label using data from the given column.

Parameters:

columnIndex - the index of the column to be used as row label.

getRowLabelColumns

@Beta
public java.util.List<java.lang.Integer> getRowLabelColumns()

addColumnLabel

@Beta
public void addColumnLabel(DataConsolidateFunction function,
                                 int columnIndex,
                                 java.lang.String valueFieldName)

Add a column label using data from the given column and specified function

Parameters:

columnIndex - the index of the column to be used as column label.

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

valueFieldName - the name of pivot table value field

addColumnLabel

@Beta
public void addColumnLabel(DataConsolidateFunction function,
                                 int columnIndex)

Add a column label using data from the given column and specified function

Parameters:

columnIndex - the index of the column to be used as column label.

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

addDataColumn

@Beta
public void addDataColumn(int columnIndex,
                                boolean isDataField)

Add column containing data from the referenced area.

Parameters:

columnIndex - the index of the column containing the data

isDataField - true if the data should be displayed in the pivot table.

addReportFilter

@Beta
public void addReportFilter(int columnIndex)

Add filter for the column with the corresponding index and cell value

Parameters:

columnIndex - index of column to filter on