com.aspose.cells

Classes

Interfaces

Constants

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.

Constructor Summary
`PivotPageFields()` Represents the pivot page field items.

Property Getters/Setters Summary
`int`	`getPageFieldCount()`
	Gets the number of page fields.

Method Summary
`void`	`addIdentify(int rangeIndex, int[] pageItemIndex)`
`void`	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.
`void`	`addPageField(java.lang.String[] pageItems)`
`void`	Adds a page field.

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