Skip to main content
.NET Framework 4.5.2+

PivotItemCollection Interface

Represents a collection of PivotItem objects in a PivotTable field.

Namespace: DevExpress.Spreadsheet

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


public interface PivotItemCollection :


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.

The following code snippets (auto-collected from DevExpress Examples) contain references to the PivotItemCollection interface.


The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also