Dokumentacija HotXLS

Add metoda

Adds a vertical page break by range, column number, or A1-style reference and returns an TXLSVPageBreak object

Sintaksa

function Add(Before: IXLSRange): TXLSVPageBreak;
function Add(BeforeCol: Integer): TXLSVPageBreak;
function Add(ARange: WideString): TXLSVPageBreak;
      
Before IXLSRange. A Range object. The range to the left of which the new page break will be added
BeforeCol One-based column before which the vertical page break will be added
ARange A1-style cell reference used to choose the column for the vertical page break

Primjer

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
  VPageBreaks.Add('G15');
  VPageBreaks.Add(9);
end;