Developer's reference PB2XLS for PowerBuilder

Reference > N_XLS_WORKSHEET

n_xls_worksheet object

A new worksheet is created by calling the of_add_worksheet() method from a workbook object.
The following methods are available through a new worksheet:

Methods

of_activate()
of_center_horizontally()
of_center_vertically()
of_fit_to_pages()
of_freeze_panes()
of_get_name()
of_get_name_unicode()
of_hide_gridlines()
of_insert_bitmap()
of_merge_write()
of_print_area()
of_print_row_col_headers()
of_protect()
of_repeat_columns()
of_repeat_rows()
of_select()
of_set_column_format()
of_set_column_width()
of_set_column_hidden()
of_set_first_sheet()
of_set_footer()
of_add_h_pagebreak()
of_set_header()
of_set_landscape()
of_set_margin_bottom()
of_set_margin_left()
of_set_margin_right()
of_set_margin_top()
of_set_margins()
of_set_margin_lr()
of_set_margin_tb()
of_set_paper()
of_set_portrait()
of_set_print_scale()
of_set_row_format()
of_set_row_height()
of_set_row_hidden()
of_set_selection()
of_add_v_pagebreak()
of_set_zoom()
of_thaw_panes()
of_write()