Developer's reference PB2XLS for PowerBuilder

Reference > Examples > example02

Example02

n_xls_workbook book
n_xls_worksheet sheet1
n_xls_worksheet sheet2
n_xls_worksheet sheet3
n_xls_worksheet sheet4

//for Excel97:
book = create n_xls_workbook_v97

//for Excel5:
//book = create n_xls_workbook_v5

book.of_create("example02.xls")

sheet1 = book.of_add_worksheet('first')
sheet2 = book.of_add_worksheet('second')
sheet3 = book.of_add_worksheet('third')
sheet4 = book.of_add_worksheet('forth')

sheet1.of_select()
sheet2.of_select()

sheet4.of_activate()

sheet1.of_set_first_sheet()

sheet4.of_set_selection ( 1, 1, 3, 3 )

book.of_close()

Screenshot