Share via

PivotItemList.Item Method

  • Article

Returns a single object from a collection.

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

Syntax

'Declaration
Function Item ( _
    Index As Object _
) As PivotItem
'Usage
Dim instance As PivotItemList
Dim Index As Object
Dim returnValue As PivotItem

returnValue = instance.Item(Index)

PivotItem Item(
    Object Index
)

Parameters

  • Index
    Type: System.Object

    Required Object. The name or index number for the object.

Return Value

Type: Microsoft.Office.Interop.Excel.PivotItem

Remarks

The text name of the object is the value of the Name and Value properties. For an Online Analytical Processing (OLAP) data source, the value is equal to the value of the SourceName property. For other data sources, the value is equal to the value of the Caption property.

See Also

Reference

PivotItemList Interface

PivotItemList Members

Microsoft.Office.Interop.Excel Namespace