PivotItemCollection Interface
Represents a collection of PivotItem objects in a PivotTable field.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v17.2.Core.dll
Declaration
public interface PivotItemCollection :
ISimpleCollection<PivotItem>,
IEnumerable<PivotItem>,
ICollection,
IEnumerableRelated API Members
The following members accept/return PivotItemCollection objects:
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.
Related GitHub Examples
The following code snippets (auto-collected from DevExpress Examples) contain references to the PivotItemCollection interface.
Note
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.