Developer's reference PB2XLS for PowerBuilder

Reference > N_XLS_WORKBOOK_V97 > of_add_worksheet

of_add_worksheet() method

Add new worksheet into workbook. You can specify the name of worksheet.

Syntax

workbook.of_add_worksheet ( { worksheetname } )

Parameters

WorksheetnameA string or a blob (unicode) whose value is the name of the worksheet you want to create. Length of worksheetname should be less then 31 symbols and it cannot contain any of the following characters: , : * ? / \

In addition, you cannot use the worksheetname for more than one worksheet

Return value

n_xls_worksheet. Returns a reference to the worksheet object. If the worksheet couldn't be created, of_add_worksheet returns NULL.

Examples

n_xls_worksheet sheet
sheet = book.of_add_worksheet( 'sheet 1' ) //create worksheet with name 'sheet 1'