PivotFieldReferenceCollection Interface

Represents the collection of row or column fields in the PivotTable report.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

public interface PivotFieldReferenceCollection :
    ISimpleCollection<PivotFieldReference>,
    IEnumerable<PivotFieldReference>,
    IEnumerable,
    ICollection

Public Interface PivotFieldReferenceCollection
    Inherits ISimpleCollection(Of PivotFieldReference),
             IEnumerable(Of PivotFieldReference),
             IEnumerable,
             ICollection

Related API Members

The following members return PivotFieldReferenceCollection objects:

• PivotTable.ColumnFields
• PivotTable.RowFields

Remarks

• Use the PivotTable.RowFields property to access the PivotFieldReferenceCollection collection of fields located in the row axis area of the pivot table.
• Use the PivotTable.ColumnFields property to access the PivotFieldReferenceCollection collection of fields located in the column axis area of the pivot table.

To get an individual row or column field by its name or index in the collection, use the PivotFieldReferenceCollection.Item property.

To add a row or column field to the pivot table, use the PivotFieldReferenceCollection.Add or PivotFieldReferenceCollection.Insert method. To remove a row or column field from the PivotTable report, use the PivotFieldReferenceCollection.Remove or PivotFieldReferenceCollection.RemoveAt method.

See Also

PivotFieldReferenceCollection Members

Pivot Tables in Spreadsheet Documents

Pivot Table Structure

WinForms Spreadsheet Control Examples

DevExpress.Spreadsheet Namespace