PivotDataFieldCollection Interface

Represents a collection of fields located in the data area of a PivotTable report.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public interface PivotDataFieldCollection :
    ISimpleCollection<PivotDataField>,
    IEnumerable<PivotDataField>,
    IEnumerable,
    ICollection

VB.NET

Public Interface PivotDataFieldCollection
    Inherits ISimpleCollection(Of PivotDataField),
             IEnumerable(Of PivotDataField),
             IEnumerable,
             ICollection

Related API Members

The following members return PivotDataFieldCollection objects:

• PivotTable.DataFields

Remarks

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.