Class PivotFieldCollection
Namespace: Aspose.Cells.Pivot
Assembly: Aspose.Cells.dll (25.2.0)
Represents a collection of all the PivotField objects in the PivotTable’s specific PivotFields type.
public class PivotFieldCollection : IEnumerableInheritance
Implements
Inherited Members
object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Properties
Count
Gets the count of the pivotFields.
public int Count { get; }Property Value
Type
Gets the PivotFields type.
public PivotFieldType Type { get; }Property Value
this[int]
Gets the PivotField Object at the specific index.
public PivotField this[int index] { get; }Property Value
this[string]
Gets the PivotField Object of the specific name.
public PivotField this[string name] { get; }Property Value
Methods
Add(PivotField)
Adds a PivotField Object to the specific type PivotFields.
public int Add(PivotField pivotField)Parameters
pivotField PivotField
a PivotField Object.
Returns
the index of the PivotField Object in this PivotFields.
AddByBaseIndex(int)
Adds a PivotField Object to the specific type PivotFields.
public int AddByBaseIndex(int baseFieldIndex)Parameters
baseFieldIndex int
field index in the base PivotFields.
Returns
the index of the PivotField Object in this PivotFields.
Clear()
clear all fields of PivotFieldCollection
public void Clear()GetEnumerator()
Gets an enumerator over the elements in this collection in proper sequence.
public IEnumerator GetEnumerator()Returns
enumerator
Move(int, int)
Moves the PivotField from current position to destination position
public void Move(int currPos, int destPos)Parameters
currPos int
Current position of PivotField based on zero
destPos int
Destination position of PivotField based on zero