Adds a horizontal page break by range, row number, o A1-style reference e returns an
TXLSHPageBreak object
Sintassi
function Add(Before: IXLSRange): TXLSHPageBreak;
function Add(BeforeRow: Integer): TXLSHPageBreak;
function Add(ARange: WideString): TXLSHPageBreak;
| Before |
IXLSRange. Un oggetto Range. L'intervallo sopra il quale verrà aggiunta la nuova interruzione di pagina |
| BeforeRow |
One-based row before which the horizontal page break will be added |
| ARange |
A1-style cell reference used to choose the row for the horizontal page break |
Esempio
This example adds a horizontal page break above cell G15 e adds a vertical page break to the left of this cell
With Workbook.Sheets[1] do
begin
HPageBreaks.Add('G15');
HPageBreaks.Add(20);
end;