PivotItems interface (Microsoft.Office.Interop.Excel)

PivotItems interface

Office 2013 and later

A collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category.

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

Syntax

No code example is currently available or this language may not be supported.

Use the PivotItems method to return the PivotItems collection.

Use PivotItems(index), where index is the item index number or name, to return a single PivotItem object.