HotXLS Docs

PrintTitleColumns property

Returns or sets the columns that contain the cells to be repeated on the left side of each page, as a string in A1-style notation. Read/write String.

Syntax

property PrintTitleColumns: string;

Remarks

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

Example

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

Workbook.Worksheets[1].PageSetup.PrintTitleRows := '$2:$2';
Workbook.Worksheets[1].PageSetup.PrintTitleColumns := '$A:$B';