officefileapi-devexpress-dot-spreadsheet-dot-worksheetprinttitleoptions-caa79f96.md
Gets or sets specific rows to be repeated on every printed page.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
CellRange Rows { get; set; }
Property Rows As CellRange
| Type | Description |
|---|---|
| CellRange |
A CellRange object that specifies worksheet rows repeated on every printed page.
If the specified cell range is not a continuous interval of entire rows, an exception is raised.
|
You can access this nested property as listed below:
| Object Type | Path to Rows |
|---|---|
| WorksheetPrintOptions |
.PrintTitles .Rows
|
Use the Rows and WorksheetPrintTitleOptions.Columns properties to set or obtain rows and columns that should appear on every printed page. Note that you can also use the WorksheetPrintTitleOptions.SetRows and WorksheetPrintTitleOptions.SetColumns methods to repeat specific rows and columns on every page when printing. For an example, refer to the How to: Print Titles on a Worksheet document.
If you don’t want row headings to appear on every printed page of your worksheet, set the Rows property to null ( Nothing in Visual Basic), or use the WorksheetPrintTitleOptions.Clear method to remove all print titles specified in the worksheet.
See Also
How to: Print Titles on a Worksheet
WorksheetPrintTitleOptions Interface