HotXLS Delphi Excel Read Write Library / Component Developers Guide loslab Inc.

Item property

Returns a single horizontal page break from a TXLSHPageBreaks collection.

Syntax

property Item[Index: Integer]: TXLSHPageBreak;
Index Required Integer. The index number of the TXLSHPageBreak object.

Example

This example copies all horizontal page breaks from first sheet to second.

var
   i: Integer;
begin

  for i := 1 to Workbook.Sheets[1].HPageBreaks.Count do 
  begin
    Workbook.Sheets[2].HPageBreaks.Add(Workbook.Sheets[1].HPageBreaks.Item[i].Location);
  end;
end;
Copyright©2007-2019 loslab.com