PivotField.RepeatLabels Property
Gets or sets whether item labels are repeated in the PivotTable for the specified PivotField.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property RepeatLabels As Boolean
Get
Set
'Usage
Dim instance As PivotField
Dim value As Boolean
value = instance.RepeatLabels
instance.RepeatLabels = value
bool RepeatLabels { get; set; }
Property Value
Type: System.Boolean
true if item labels are repeated in the PivotTable for the specified PivotField; otherwise false.
Remarks
Read/write.
true if item labels are repeated for the specified PivotField; otherwise false.The setting of the RepeatLabels property corresponds to the Repeat item labels check box on the Layout & Print tab of the Field Settings dialog box for a field in a PivotTable.To specify whether to repeat item labels for all PivotFields in a PivotTable in a single operation, use the RepeatAllLabels(XlPivotFieldRepeatLabels) method.