Add(This example adds a horizontal page break above cell G15 and adds a vertical page break to the left of this cell: WideString):
function Add(Before: IXLSRange): TXLSHPageBreak;
function Add(BeforeRow: Integer): TXLSHPageBreak;
function Add(ARange: WideString): TXLSHPageBreak;
| Before |
One-based row before which the horizontal page break will be added |
| One-based row before which the horizontal page break will be added |
A1-style cell reference used to choose the row for the horizontal page break |
| This example adds a horizontal page break above cell G15 and adds a vertical page break to the left of this cell |
With |
begin
With Workbook.Sheets[1] do
begin
HPageBreaks.Add('G15');
HPageBreaks.Add(20);
end;