Reference>TXLSVPageBreaks>Item

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;

NativeExcel suite v1.x

Item property

Syntax

Example