aspose.cells

Classes

Constants

Class PivotFieldCollection

Represents a collection of all the PivotField objects in the PivotTable's specific PivotFields type.

Property Getters/Setters Summary
`function`	`getCount()`
	Gets the count of the pivotFields.
`function`	`getType()`
	Gets the PivotFields type. The value of the property is PivotFieldType integer constant.
`function`	`get(index)`
	Gets the PivotField Object at the specific index.
`function`	`get(name)`
	Gets the PivotField Object of the specific name.

Method Summary
`function`	`add(pivotField)`
`function`	Adds a PivotField Object to the specific type PivotFields.
`function`	`addByBaseIndex(baseFieldIndex)`
`function`	Adds a PivotField Object to the specific type PivotFields.
`function`	`clear()`
`function`	clear all fields of PivotFieldCollection
`function`	`iterator()`
`function`	Gets an enumerator over the elements in this collection in proper sequence.

- Property Getters/Setters Detail
  - getType : Number
```
function getType()
```
    Gets the PivotFields type. The value of the property is PivotFieldType integer constant.
  - getCount : Number
```
function getCount()
```
    Gets the count of the pivotFields.
  - get : PivotField
```
function get(index)
```
    Gets the PivotField Object at the specific index.
  - get : PivotField
```
function get(name)
```
    Gets the PivotField Object of the specific name.
- Method Detail
  - iterator
```
function iterator()
```
    Gets an enumerator over the elements in this collection in proper sequence.
    Returns:
    enumerator
  - addByBaseIndex
```
function addByBaseIndex(baseFieldIndex)
```
    Adds a PivotField Object to the specific type PivotFields.
    Parameters:
    baseFieldIndex: Number - field index in the base PivotFields.
    Returns:
    the index of the PivotField Object in this PivotFields.
  - add
```
function add(pivotField)
```
    Adds a PivotField Object to the specific type PivotFields.
    Parameters:
    pivotField: PivotField - a PivotField Object.
    Returns:
    the index of the PivotField Object in this PivotFields.
  - clear
```
function clear()
```
    clear all fields of PivotFieldCollection