officefileapi-devexpress-dot-spreadsheet-dot-worksheetprintoptions-6507d346.md
Provides access to an object used to specify rows and columns to be repeated on every printed page.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
WorksheetPrintTitleOptions PrintTitles { get; }
ReadOnly Property PrintTitles As WorksheetPrintTitleOptions
| Type | Description |
|---|---|
| WorksheetPrintTitleOptions |
A WorksheetPrintTitleOptions object that specifies titles to be repeated on every printed page.
|
You can access this nested property as listed below:
| Object Type | Path to PrintTitles |
|---|---|
| Worksheet |
.PrintOptions .PrintTitles
|
Use the PrintTitles property to get access to an object that allows you to repeat specific rows at the top of every printed page (WorksheetPrintTitleOptions.Rows, WorksheetPrintTitleOptions.SetRows), or specific columns on the left side of every printed page (WorksheetPrintTitleOptions.Columns, WorksheetPrintTitleOptions.SetColumns). For an example, refer to the How to: Print Titles on a Worksheet article.
To remove print titles from a worksheet, use the WorksheetPrintTitleOptions.Clear method.
// Access an object that contains print options.
WorksheetPrintOptions printOptions = worksheet.PrintOptions;
// Print the first column and the first row on every page.
printOptions.PrintTitles.SetColumns(0, 0);
printOptions.PrintTitles.SetRows(0, 0);
' Access an object that contains print options.
Dim printOptions As WorksheetPrintOptions = worksheet.PrintOptions
' Print the first column and the first row on every page.
printOptions.PrintTitles.SetColumns(0, 0)
printOptions.PrintTitles.SetRows(0, 0)
See Also
How to: Print Titles on a Worksheet