Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Another ? on Exporting to EXCEL.
Message
De
09/06/1999 21:45:35
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00228180
Message ID:
00228224
Vues:
16
>I'm finding it necessary to export data to a series of Excel spreadsheets. Not a problem, EXCEPT how do I export to multiple PAGES? i.e., stuff meeting condition A goes to Page 1, condition B to page 2, etc... No help in my VFP documentation, at least not that I could find. I'd like to be able to handle this completely within the VFP code, rather than having to manipulate the data within Excel to break it out to its respective pages.
>
>Thanks.


VFP's COPY TO .. TYPE XLS will only get you so far. For anything more than the very most basic exports, you should be automating excel, and building the spreadsheet by scanning through your table. Check the solutions sample app for ideas on how to get started on this, and use the Excel Object browser in the VBA editor to get you past that.

It's going to take a little more work than COPY TO...
Erik Moore
Clientelligence
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform