HotXLS Docs

PrintTitleRows property

Yields 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;

Notes

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';