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): TXLSVPageBreak;
function Add(BeforeCol: Integer): TXLSVPageBreak;
function Add(ARange: WideString): TXLSVPageBreak;
| Before |
One-based column before which the vertical page break will be added |
| One-based column before which the vertical page break will be added |
A1-style cell reference used to choose the column for the vertical 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
VPageBreaks.Add('G15');
VPageBreaks.Add(9);
end;