PivotItems Interface

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

'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("00020877-0000-0000-C000-000000000046")> _
Public Interface PivotItems _
    Inherits IEnumerable
'Usage
Dim instance As PivotItems
[InterfaceTypeAttribute()]
[GuidAttribute("00020877-0000-0000-C000-000000000046")]
public interface PivotItems : IEnumerable

Remarks

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.

See Also

Reference

PivotItems Members

Microsoft.Office.Interop.Excel Namespace