HotXLS Delphi Excel Read Write Library / Component Developers Guide loslab Inc.
Reference > TXLSHPageBreak > Location

Location property

Returns the cell (a IXLSRange object) that defines the horizontal page-break location. Horizontal page breaks are aligned with the top edge of the location cell. Read only IXLSRange.

Syntax

property Location: IXLSRange;

Example

This example sets the interior color of the page-break location to red. 

Workbook.Sheets[1].HPageBreaks.Item[1].Location.Interior.Color := xlRed;
Copyright©2014 loslab.com