Developer's reference PB2XLS for PowerBuilder

Reference > Examples > example04

Example04

n_xls_workbook book
n_xls_worksheet sheet1

//for Excel97:
book = create n_xls_workbook_v97

//for Excel5:
//book = create n_xls_workbook_v5

book.of_create("example04.xls")

sheet1 = book.of_add_worksheet('1')
sheet1.of_freeze_panes(1, 1, 5, 10)
book.of_close()

Screenshot