HotXLS Docs

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. Read/write String.

Syntax

property PrintTitleRows: string;

Remarks

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

Example

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

Workbook.Worksheets[1].PageSetup.PrintTitleRows := '$3:$3';
Workbook.Worksheets[1].PageSetup.PrintTitleColumns := '$A:$C';