com.aspose.cells
Class PivotPageFields
java.lang.Object
com.aspose.cells.PivotPageFields
public class PivotPageFields
- extends java.lang.Object
Represents the pivot page field items
if the pivot table data source is consolidation ranges.
It only can contain up to 4 fields.
Method Summary |
void |
addIdentify(int rangeIndex,
int[] pageItemIndex)
Sets which item label in each page field to use to identify the data range. |
void |
addPageField(java.lang.String[] pageItems)
Adds a page field. |
int |
sizeOfPageFields()
Gets the number of page fields. |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
PivotPageFields
public PivotPageFields()
addPageField
public void addPageField(java.lang.String[] pageItems)
- Adds a page field.
- Parameters:
pageItems
- Page field item label
sizeOfPageFields
public int sizeOfPageFields()
- Gets the number of page fields.
- Returns:
- the number of page fields.
addIdentify
public void addIdentify(int rangeIndex,
int[] pageItemIndex)
- Sets which item label in each page field to use to identify the data range.
The pageItemIndex.Length must be equal to PageFieldCount, so please add the page field first.
- Parameters:
rangeIndex
- The consilidation data range index.pageItemIndex
- The page item index in the each page field.
pageItemIndex[2] = 1 means the seconde item in the third field to use to identify this range.
pageItemIndex[1] = -1 means no item in the second field to use to identify this range
and MS will auto create "blank" item in the second field to identify this range.