Release 1.6.1 29 June 2005

Developer's reference

Example05

n_xls_workbook book
n_xls_worksheet sheet1
n_xls_format format1

//for Excel97:
book = create n_xls_workbook_v97

//for Excel5:
//book = create n_xls_workbook_v5

book.of_create("example05.xls")
book.of_set_custom_color(36, 240, 240, 240)

sheet1 = book.of_add_worksheet('sheet 1')

sheet1.of_set_paper(11)
sheet1.of_set_landscape()
sheet1.of_set_margins(2)
sheet1.of_set_header('&LLeft header&C&20Center header', 0.5)
sheet1.of_set_footer('&LLeft footer&C&8Center footer', 0.5)
sheet1.of_set_print_scale(140)

format1 = book.of_add_format()
format1.of_set_bg_color(36)

sheet1.of_write(0,0, 'Check  print preview...', format1)
sheet1.of_set_column_width(0, 60)
book.of_close()

Screenshot