Partager via

PivotTable.VisibleFields Property

  • Article

Returns an object that represents either a single field in a PivotTable report (a PivotField object) or a collection of all the visible fields (a PivotFields object). Visible fields are shown as row, column, page, or data fields. Read-only.

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

Syntax

'Declaration
ReadOnly Property VisibleFields ( _
    Index As Object _
) As Object
    Get
'Usage
Dim instance As PivotTable
Dim Index As Object
Dim value As Object

value = instance.VisibleFields(Index)

Object this[
    Object Index
] { get; }

Parameters

  • Index
    Type: System.Object

    Optional Object. The name or number of the field to be returned (can be an array to specify more than one field).

Property Value

Type: System.Object

Remarks

For OLAP data sources there are no hidden fields, and this property returns all the fields in the PivotTable cache.

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace