Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting Data To Excel...
Message
From
03/10/2005 02:17:50
 
 
To
30/09/2005 18:17:42
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01055133
Message ID:
01055419
Views:
12
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
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Reply
Map
View

Click here to load this message in the networking platform