Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Another ? on Exporting to EXCEL.
Message
From
09/06/1999 21:45:35
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00228180
Message ID:
00228224
Views:
14
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform