Class PivotFieldCollection

PivotFieldCollection class

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

public class PivotFieldCollection : IEnumerable

Properties

NameDescription
Count { get; }Gets the count of the pivotFields.
Item { get; }Gets the PivotField Object at the specific index. (2 indexers)
Type { get; }Gets the PivotFields type.

Methods

NameDescription
Add(PivotField)Adds a PivotField Object to the specific type PivotFields.
AddByBaseIndex(int)Adds a PivotField Object to the specific type PivotFields.
Clear()clear all fields of PivotFieldCollection
GetEnumerator()Gets an enumerator over the elements in this collection in proper sequence.
Move(int, int)Moves the PivotField from current position to destination position

See Also