Home Contents Overview

TXLSHPageBreaks class

Unit: lxHandle

A collection of horizontal page breaks within the print area. Each horizontal page break is represented by a TXLSHPageBreak object.

Properties

Count property

Item property

Methods

Add method

Example

This example inserts a horizontal page break before row 25 and then checks how many horizontal page breaks the worksheet contains.

var
  Sheet: IXLSWorksheet;
begin
  Sheet := Workbook.Sheets[1];
  Sheet.HPageBreaks.Add(Sheet.Range['A25', 'A25']);

  if Sheet.HPageBreaks.Count > 0 then
    Sheet.PageSetup.PrintGridlines := True;
end;

See also

TXLSHPageBreaks.Add method
TXLSHPageBreak class
TXLSVPageBreaks class