PivotTable.ShowValuesRow Property
Gets or sets whether the values row is displayed.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property ShowValuesRow As Boolean
Get
Set
'Usage
Dim instance As PivotTable
Dim value As Boolean
value = instance.ShowValuesRow
instance.ShowValuesRow = value
bool ShowValuesRow { get; set; }
Property Value
Type: System.Boolean
true if the values row is displayed; otherwise, false.
Remarks
Read/write.
This property corresponds to the setting of the Show the Values row check box on the Display tab of the PivotTable Options dialog box.