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

PivotItemCollection Interface

Represents a collection of PivotItem objects in a PivotTable field.

Namespace: DevExpress.Spreadsheet

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

Declaration

public interface PivotItemCollection :
    ISimpleCollection<PivotItem>,
    IEnumerable<PivotItem>,
    IEnumerable,
    ICollection
Public Interface PivotItemCollection
    Inherits ISimpleCollection(Of PivotItem),
             IEnumerable(Of PivotItem),
             IEnumerable,
             ICollection
public interface PivotItemCollection :
    ISimpleCollection<PivotItem>,
    IEnumerable<PivotItem>,
    IEnumerable,
    ICollection
Public Interface PivotItemCollection
    Inherits ISimpleCollection(Of PivotItem),
             IEnumerable(Of PivotItem),
             IEnumerable,
             ICollection
public interface PivotItemCollection :
    ISimpleCollection<PivotItem>,
    IEnumerable<PivotItem>,
    IEnumerable,
    ICollection
Public Interface PivotItemCollection
    Inherits ISimpleCollection(Of PivotItem),
             IEnumerable(Of PivotItem),
             IEnumerable,
             ICollection

Remarks

When you create a pivot table, the PivotItemCollection collection is populated automatically with the unique data entries retrieved for each field from the source data. To return a collection of items contained in a specific PivotTable field, use the PivotField.Items property. An individual PivotItem object can be accessed by its index in the collection.

If you add a calculated item to the PivotField.CalculatedItems collection of a PivotTable field, it's also automatically added to the field's PivotItemCollection collection.

See Also