PivotItemCollection Interface

Represents a collection of PivotItem objects in a PivotTable field.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public interface PivotItemCollection :
    ISimpleCollection<PivotItem>,
    IEnumerable<PivotItem>,
    IEnumerable,
    ICollection

VB.NET

Public Interface PivotItemCollection
    Inherits ISimpleCollection(Of PivotItem),
             IEnumerable(Of PivotItem),
             IEnumerable,
             ICollection

Related API Members

The following members return PivotItemCollection objects:

• PivotField.Items

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.