HotXLS Docs

TXLSVPageBreaks class

Unit: lxHandle
A collection of vertical page breaks within the print area. Each vertical page break is represented by a TXLSVPageBreak object.

Properties

Methods

Example

This example inserts a vertical page break before column G and then checks how many vertical page breaks the worksheet contains.

var
  Sheet: IXLSWorksheet;
begin
  Sheet := Workbook.Sheets[1];
  Sheet.VPageBreaks.Add(Sheet.Range['G1', 'G1']);

  if Sheet.VPageBreaks.Count > 0 then
    Sheet.PageSetup.PrintHeadings := True;
end;

See also