Reference>TXLSHPageBreaks>Item

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;

Item property

Syntax

Example