Home  Products  Purchase  Downloads  Demos  Forums  Blogs  Ticket  Wiki  API  Corporate


com.aspose.cells
Class PivotPageFields

java.lang.Object
  extended by 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.


Constructor Summary
PivotPageFields()
           
 
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
 

Constructor Detail

PivotPageFields

public PivotPageFields()
Method Detail

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.