Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export to EXCEL
Message
From
05/04/2005 02:51:08
 
 
To
01/04/2005 19:10:17
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01000912
Message ID:
01001413
Views:
11
Hi Jeff,

You can have look at my Rep2Excel tool here in downloads. (Sept 2002)
Class objects is made of bunch of wrappers for common automation tasks.
So you can export your data any way you like using very simple calls like;

oXl.table_in_section(1,10,15,'YourTable','field1|field2|...')
(Strating at 1st sheet,10th row,15th column)

oXl.table_in_section(2,1,2,'YourTable','field1|field2|...')
(Strating at 2nd sheet,1st row,2nd column)

etc

It will be slow for bigger tables, since it uses OLE automation calls to write, but it can spare you of lot of excel macros converting / coding.

Rgds++
Sergio




>Hello,
>
>I am using VFP8 - is there a way to export to excel and not include the
>field names in the first record?
>
>Also, is there a way to export to multiple sheets in Excel?
>
>Thanks,
>
>Jeff
*****************
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