aspose.cells

Classes

Constants

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

Method Summary
`function`	`addIdentify(rangeIndex, pageItemIndex)`
`function`	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.
`function`	`addPageField(pageItems)`
`function`	Adds a page field.

- Constructor Detail
  - PivotPageFields
```
function PivotPageFields()
```
    Represents the pivot page field items.
- Property Getters/Setters Detail
  - getPageFieldCount : Number
```
function getPageFieldCount()
```
    Gets the number of page fields.
- Method Detail
  - addPageField
```
function addPageField(pageItems)
```
    Adds a page field.
    Parameters:
    pageItems: String[] - Page field item label
  - addIdentify
```
function 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: Number - 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.