Developer's reference PB2XLS for PowerBuilder

Reference > N_XLS_WORKSHEET > of_repeat_rows

of_repeat_rows() method

Set the number of rows to repeat at the top of each printed page.

Syntax

worksheet.of_repeat_rows ( first_row, last_row )

Parameters

First_rowThe unsigned integer whose value is the number of first row
Last_rowThe unsigned integer whose value is the number of last row

Return value

Integer. Returns 1 if it succeeds and -1 if an error occurs.

Description

For large Excel documents it is often desirable to have the first row or rows of the worksheet print out at the top of each page. This can be achieved by using the of_repeat_rows() method. The parameters first_row and last_row are zero based.

Examples

worksheet1.of_repeat_rows(0, 0)     //Repeat the first row
worksheet2.of_repeat_rows(0, 2)     //Repeat the first three rows