asposecells.api
Class PivotPageFields

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()
           Represents the pivot page field items.
 
Property Getters/Setters Summary
methodgetPageFieldCount()
           Gets the number of page fields.
 
Method Summary
methodaddIdentify(rangeIndex, 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.
methodaddPageField(pageItems)
           Adds a page field.
 

Constructor Detail

PivotPageFields

PivotPageFields()
Represents the pivot page field items.

Property Getters/Setters Detail

getPageFieldCount : int 

int getPageFieldCount()
Gets the number of page fields.

Method Detail

addPageField

 addPageField(pageItems)
Adds a page field.
Parameters:
pageItems: String[] - Page field item label

addIdentify

 addIdentify(rangeIndex, 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: int - The consolidation data range index.
pageItemIndex: Number Array - 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.

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.