HotXLS Docs
Home Contents Overview

Item property

Returns a single vertical page break from a TXLSVPageBreaks collection.

Syntax

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

Example

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

var
   i: Integer;
begin

  for i := 1 to Workbook.Sheets[1].VPageBreaks.Count do 
  begin
    Workbook.Sheets[2].VPageBreaks.Add(Workbook.Sheets[1].VPageBreaks.Item[i].Location);
  end;
end;