Dokumentacija HotXLS

Add metoda

Doda vodoravni prelom strani po obsegu, številki vrstice ali sklicu v zapisu A1 in vrne TXLSHPageBreak object

Skladnja

function Add(Before: IXLSRange): TXLSHPageBreak;
function Add(BeforeRow: Integer): TXLSHPageBreak;
function Add(ARange: WideString): TXLSHPageBreak;
      
Before IXLSRange. Objekt Range. Obseg, nad katerim bo dodan nov prelom strani
BeforeRow One-based row before which the horizontal page break will be added
ARange A1-style cell reference used to choose the row for the horizontal page break

Primer

Primer doda vodoravni prelom strani nad celico G15 in navpični prelom strani levo od te celice

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