officefileapi-devexpress-dot-spreadsheet-c85bfadb.md
Represents a collection of PivotItem objects in a PivotTable field.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public interface PivotItemCollection :
ISimpleCollection<PivotItem>,
IEnumerable<PivotItem>,
IEnumerable,
ICollection
Public Interface PivotItemCollection
Inherits ISimpleCollection(Of PivotItem),
IEnumerable(Of PivotItem),
IEnumerable,
ICollection
The following members return PivotItemCollection objects:
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 is also automatically added to the field’s PivotItemCollection collection.
See Also
Pivot Tables in Spreadsheet Documents