collection Use VPageBreaks.Item[index], where index is the index number of the page break, to return an TXLSVPageBreak object
'H1'
This example adds a vertical page break, formats its location column, and then removes the break when the report should print as a single page wide
Sheet: TXLSWorksheet; BreakItem: TXLSVPageBreak;
|
]; BreakItem := Sheet.VPageBreaks.Add(Sheet.Range[
|
'H1'
This example adds a vertical page break, formats its location column,
and then removes the break when the report should print as a single
page wide
var
Sheet: TXLSWorksheet;
BreakItem: TXLSVPageBreak;
begin
Sheet := Workbook.Sheets[1];
BreakItem := Sheet.VPageBreaks.Add(Sheet.Range['H1', 'H1']);
BreakItem.Location.Interior.Color := xlYellow;
if Sheet.VPageBreaks.Count > 1 then
BreakItem.Delete;
end;
then