Hi There :)

You can try my 'rep2excel' tool here in downloads
it can perform that in couple lines of code like ;

oXl=createobject('write_2_excel')
oXl.open_excel()
oXl.table_in_section (1,5,2,'Employee',"Employee.first_name|Employee.last_name|Employee.address|Employee.city|Employee.hire_date")

Sample above wld write alias 'employee' starting at 1st sheet,5th row ,2nd column.

You can also write arrays,delimited strings,draw boxes and many other things using 3d or 2d positioning.

oXl.draw_box(4,2,4,6,  8)        
oXL.values_in_row(1,4,2,"First Name |Last Name|Address|City|Hire Date")
oXL.box_set_font(4,1,oXl.current_row,6,'Arial',8,.t.)                          

See samples there for more.


If table is to big then is better to use _dataclip sample provided already in this thread, as OLE automation used by my tool wld be to slow.

Rgds++
Sergio