Hi Onelio,
You can have look at my 'rep2excel' tool here in downloads.
It is class object having most of common excel writing tasks
wrapped into simple methods calls.
oXl.table_in_section(nSheet,nRow,nCol, cAlias,'field1|field2|...')
oXl.array_in_section(nSheet,nRow,nCol, &MyArray)
oXl.draw_box(nTop,nLeft,nDown,nRight,nColor)
oXl.insert_picture(nSheet,nRow,nCol, cBmpFile)
etc.
If you need to write fully blown reports with grouping,headers,footers etc,
you can try 'CodeRep' which uses the same excel automation to write report to excel file.
Both are free with full source & samples included.
Rgds++
Sergio
>Hello There...
>
> Don't know if this is the place to ask about my doubt/problem, but there it goes...
>
> I want to export my data into a Excel file, but I want the result file to be formatted so I can open it and send it to the printer. How can I give the format to a file via coding so the result excel file will be like I wish?
>
> Thanks in advance...!!!
>
>Onelio