Skip to main content
Row

PivotFieldReferenceCollection Methods

Represents the collection of row or column fields in the PivotTable report.
Name Description
Add(PivotField) Adds a field to the row or column area of the pivot table.
AddValuesReference() Adds the virtual “Values” field to the row or column area of the pivot table.
Clear() Removes all row or column fields from the collection.
Contains(PivotFieldReference) Determines whether the collection contains the specified column or row field.
CopyTo(Array, Int32) Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection.
GetEnumerator() Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>.
IndexOf(PivotFieldReference) Returns the index of the specified row or column field in the collection.
Insert(Int32, PivotField) Inserts a row or column field into the collection at the specified index.
InsertValuesReference(Int32) Inserts the virtual “Values” field into the collection at the specified index.
Remove(PivotFieldReference) Removes the specified row or column field from the collection.
RemoveAt(Int32) Removes the row or column field at the specified index from the collection.
See Also