Release 1.6.1 29 June 2005

Developer's reference

Example06

n_xls_workbook book
n_xls_worksheet sheet1
n_xls_format format1
uint i, j

//for Excel97:
book = create n_xls_workbook_v97

//for Excel5:
//book = create n_xls_workbook_v5

book.of_create("example06.xls")

sheet1 = book.of_add_worksheet('sheet 1')
format1 = book.of_add_format()
for i = 1 to 100
   for j = 1 to 5
     sheet1.of_write(i - 1, j - 1, i * j, format1)
   next
next

sheet1.of_repeat_rows(0, 0)
sheet1.of_print_row_col_headers(true)

book.of_close()

Screenshot