Release 1.6.1 29 June 2005

Developer's reference

Example08

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("example08.xls")

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

sheet1.of_print_area(1, 2, 5, 7)
sheet1.of_add_h_pagebreak(3)
sheet1.of_add_v_pagebreak(4)

book.of_close()

Screenshot