Add method - HotXLS Developer Reference

Adds a vertical page break. Returns an TXLSVPageBreak object.

Syntax

function Add(Before: IXLSRange): TXLSVPageBreak;

Before

IXLSRange. A Range object. The range to the left of which the new page break will be added.

This example adds a horizontal page break above cell G15 and adds a vertical page break to the left of this cell.

With Workbook.Sheets[1] do 
begin
  HPageBreaks.Add(Range['G15', 'G15']);
  VPageBreaks.Add(Range['G15', 'G15']);
end;