Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Export to EXCEL
Message
De
05/04/2005 02:51:08
 
 
À
01/04/2005 19:10:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01000912
Message ID:
01001413
Vues:
10
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform