PivotItemList interface

Office 2013 and later

A collection of all the PivotItem objects in the specified PivotTable. Each PivotItem represents an item in a PivotTable field.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

Use the RowItems or ColumnItems property of the PivotCell object to return a PivotItemList collection.

Once a PivotItemList collection is returned, you can use the Item method to identify a particular PivotItem list.

Show: