asposecells.api

Classes

Constants

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
`method`	`getPageFieldCount()`
	Gets the number of page fields.

Method Summary
`method`	`addIdentify(rangeIndex, pageItemIndex)`
`method`	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.
`method`	`addPageField(pageItems)`
`method`	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 second 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.