officefileapi-devexpress-dot-spreadsheet-f96ea146.md
Represents a collection of fields located in the data area of a PivotTable report.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public interface PivotDataFieldCollection :
ISimpleCollection<PivotDataField>,
IEnumerable<PivotDataField>,
IEnumerable,
ICollection
Public Interface PivotDataFieldCollection
Inherits ISimpleCollection(Of PivotDataField),
IEnumerable(Of PivotDataField),
IEnumerable,
ICollection
The following members return PivotDataFieldCollection objects:
The PivotDataFieldCollection object stores all data fields added to a PivotTable report. Use the PivotTable.DataFields property to access this collection. The PivotDataFieldCollection.Item property enables you to get an individual data field by its name or index in the collection.
To add a data field to the pivot table, use the PivotDataFieldCollection.Add or PivotDataFieldCollection.Insert method. To remove a data field from the PivotTable report, use the PivotDataFieldCollection.Remove or PivotDataFieldCollection.RemoveAt method.
See Also
PivotDataFieldCollection Members
Pivot Tables in Spreadsheet Documents