29 June 2005
| Release 1.6.1 29 June 2005 |
Developer's reference |
|
| Reference > N_XLS_WORKSHEET > of_repeat_columns |
of_repeat_columns() method
Set the columns to repeat at the left hand side of each printed page.
Syntax
| worksheet.of_repeat_columns ( first_column, last_column ) |
Parameters
| First_column | The unsigned integer whose value is the number of first column |
| Last_column | The unsigned integer whose value is the number of last column |
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 column or columns of the worksheet print out at the left hand side of each page. This can be achieved by using the of_repeat_columns() method. The parameters first_column and last_column are zero based.
Examples
worksheet1.of_repeat_columns(0, 0) //Repeat the first column worksheet2.of_repeat_columns(0, 2) //Repeat the first three columns
| © 2003-2005 Desta, Ltd. All rights reserved. | SupportDesk |