.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotDataFieldCollection Methods

Represents a collection of fields located in the data area of a PivotTable report.
Name Description
Add(PivotField) Adds a field to the data area of a PivotTable report.
Add(PivotField, String) Adds a field to the data area of a PivotTable report.
Add(PivotField, String, PivotDataConsolidationFunction) Adds a field to the data area of a PivotTable report.
Clear() Removes all data fields from the collection.
Contains(PivotDataField) Determines whether the collection contains the specified data 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(PivotDataField) Returns the index of the specified data field in the collection.
Insert(Int32, PivotField) Inserts a field into the data area of a PivotTable report at the specified position.
Insert(Int32, PivotField, String) Inserts a field into the data area of a PivotTable report at the specified position.
Insert(Int32, PivotField, String, PivotDataConsolidationFunction) Inserts a field into the data area of a PivotTable report at the specified position.
Remove(PivotDataField) Removes the specified data field from the collection.
RemoveAt(Int32) Removes the data field at the specified index from the collection.
See Also