PivotField.RepeatLabels Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets whether item labels are repeated in the PivotTable for the specified PivotField.

public:
 property bool RepeatLabels { bool get(); void set(bool value); };

public bool RepeatLabels { get; set; }

Public Property RepeatLabels As Boolean

Property Value

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.

Applies to