Compartilhar via


PivotField.PivotItems Method

Returns an object that represents either a single PivotTable item (a PivotItem object) or a collection of all the visible and hidden items (a PivotItems object) in the specified field. Read-only.

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

Syntax

'Declaration
Function PivotItems ( _
    Index As Object _
) As Object
'Usage
Dim instance As PivotField
Dim Index As Object
Dim returnValue As Object

returnValue = instance.PivotItems(Index)
Object PivotItems(
    Object Index
)

Parameters

  • Index
    Type: System.Object

    Optional Object. The name or number of the item to be returned.

Return Value

Type: System.Object

Remarks

For OLAP data sources, the collection is indexed by the unique name (the name returned by the SourceName property), not by the display name.

See Also

Reference

PivotField Interface

PivotField Members

Microsoft.Office.Interop.Excel Namespace