PivotTable.PrintTitles 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.

True if the print titles for the worksheet are set based on the PivotTable report. False if the print titles for the worksheet are used. The default value is False. Read/write Boolean.

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

public bool PrintTitles { get; set; }

Public Property PrintTitles As Boolean

Property Value

Boolean

Remarks

The row print titles are set to the rows that contain the PivotTable report’s column field items. The column print titles are set to the columns that contain the row items.

The PivotTable report must be the only one in the print area. To set an indented format for a PivotTable report, use the Format(XlPivotFormatType) method.

Applies to