Skip to main content
Row

PivotDataFieldCollection Interface

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

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

The following members return PivotDataFieldCollection objects:

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.

See Also