NativeExcel2 for .Net Developer's Reference

IPageSetup.PrintTitleRows Property

Returns or sets the rows that contain the cells to be repeated at the top of each page, as a string in A1-style notation.

[Visual Basic]
PropertyPrintTitleRowsAsString
[C#]
stringPrintTitleRows{get;set;}
[C++]
__propertyString*get_PrintTitleRows();
__propertyvoidset_PrintTitleRows(String*);
[JScript]
functiongetPrintTitleRows():String
functionsetPrintTitleRows(String);

Remarks

Set this property to the empty string to turn off title rows.

Example

This example defines row two as the title row, and it defines columns one through two as the title columns.

[C#]
book.Worksheets[1].PageSetup.PrintTitleRows = "$2:$2";
book.Worksheets[1].PageSetup.PrintTitleColumns = "$A:$B";
[VisualBasic]
book.Worksheets(1).PageSetup.PrintTitleRows = "$2:$2"
book.Worksheets(1).PageSetup.PrintTitleColumns = "$A:$B"
[C++]
book->Worksheets->Item[1]->PageSetup->PrintTitleRows = S"$2:$2";
book->Worksheets->Item[1]->PageSetup->PrintTitleColumns = S"$A:$B";

See Also

IPageSetup Interface | NativeExcel Namespace | PageSetup Property | PrintTitleColumns Property | SetPrintTitleRows Method | PrintTitleRowsDefined Property