PivotFieldCollection
Contents
[
Hide
]PivotFieldCollection class
Represents a collection of all the PivotField objects in the PivotTable’s specific PivotFields type.
class PivotFieldCollection;
Methods
| Method | Description |
|---|---|
| get(number) | Gets the PivotField Object at the specific index. |
| getType() | Gets the PivotFields type. |
| getCount() | Gets the count of the pivotFields. |
| getEnumerator() | Gets an enumerator over the elements in this collection in proper sequence. |
| addByBaseIndex(number) | Adds a PivotField Object to the specific type PivotFields. |
| add(PivotField) | Adds a PivotField Object to the specific type PivotFields. |
| clear() | clear all fields of PivotFieldCollection |
| move(number, number) | Moves the PivotField from current position to destination position |
get(number)
Gets the PivotField Object at the specific index.
get(index: number) : PivotField;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| index | number |
Returns
getType()
Gets the PivotFields type.
getType() : PivotFieldType;
Returns
getCount()
Gets the count of the pivotFields.
getCount() : number;
getEnumerator()
Gets an enumerator over the elements in this collection in proper sequence.
getEnumerator() : PivotFieldEnumerator;
Returns
enumerator
addByBaseIndex(number)
Adds a PivotField Object to the specific type PivotFields.
addByBaseIndex(baseFieldIndex: number) : number;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| baseFieldIndex | number | field index in the base PivotFields. |
Returns
the index of the PivotField Object in this PivotFields.
add(PivotField)
Adds a PivotField Object to the specific type PivotFields.
add(pivotField: PivotField) : number;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| pivotField | PivotField | a PivotField Object. |
Returns
the index of the PivotField Object in this PivotFields.
clear()
clear all fields of PivotFieldCollection
clear() : void;
move(number, number)
Moves the PivotField from current position to destination position
move(currPos: number, destPos: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| currPos | number | Current position of PivotField based on zero |
| destPos | number | Destination position of PivotField based on zero |