PivotFieldCollection
Source: aspose.
Represents a collection of all the PivotField objects in the PivotTable's specific PivotFields type.
Methods
add(pivotField) → Number
Adds a PivotField Object to the specific type PivotFields.
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
pivotField |
|
a PivotField Object. |
- Returns
-
Numberthe index of the PivotField Object in this PivotFields.
addByBaseIndex(baseFieldIndex) → Number
Adds a PivotField Object to the specific type PivotFields.
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
baseFieldIndex |
Number |
|
field index in the base PivotFields. |
- Returns
-
Numberthe index of the PivotField Object in this PivotFields.
clear()
clear all fields of PivotFieldCollection
get()
Gets the PivotField Object at the specific index.
get()
Gets the PivotField Object of the specific name.
getCount()
Gets the count of the pivotFields.
getType()
Gets the PivotFields type. The value of the property is PivotFieldType integer constant.
iterator() → Iterator
Gets an enumerator over the elements in this collection in proper sequence.
- Returns
-
Iteratorenumerator
move(currPos, destPos)
Moves the PivotField from current position to destination position
Parameters
| Name | Type | Optional | Description |
|---|---|---|---|
|
currPos |
Number |
|
Current position of PivotField based on zero |
|
destPos |
Number |
|
Destination position of PivotField based on zero |