Release 1.6.1 29 June 2005

Developer's reference

Example01

n_xls_workbook book
n_xls_worksheet sheet
n_xls_format format1
n_xls_format format2
n_xls_format format3

//for Excel97:
book = create n_xls_workbook_v97

//for Excel5:
//book = create n_xls_workbook_v5

book.of_create("example01.xls")
sheet = book.of_add_worksheet('sheet 1')
format1 = book.of_add_format()
format1.of_set_align('center')
sheet.of_merge_write ( 0, 0, 0, 3, 'Hello world', format1 )

format2 = book.of_add_format()
format2.of_set_align('vcenter')
format2.of_set_align('center')
format2.of_set_num_format('#,##0.00')
sheet.of_merge_write ( 1, 0, 3, 0, 100, format2 )

format3 = book.of_add_format()
format3.of_set_align('vcenter')
format3.of_set_align('center')
format3.of_set_num_format('dd.mm.yyyy hh:mm:ss')
sheet.of_merge_write ( 1, 1, 3, 1, datetime(today(), now()), format3 )

sheet.of_set_column_width(1, 25)

book.of_close()

Screenshot