Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to send values to an Excel Spreadsheet
Message
From
07/01/1999 17:03:10
 
 
To
07/01/1999 16:52:16
General information
Forum:
Visual FoxPro
Category:
Windows API functions
Miscellaneous
Thread ID:
00173811
Message ID:
00173817
Views:
27
Hi Gerry ---

You can create an Excel Application object via Automation in VFP and run the show that way. The Excel object model, which allows you to do virutally anything in Excel is documented in "Visual Basic Help" in the Excel Help Menu.

I don't have Excel here where I'm at today, but, basically, creating an Excel spreadsheet would go like:

=oExcelSheet = CREATEOBJECT("Excel.Sheet")
=oExcelSheet.Print



>I have to take a handfull of text and numeric values from within a FoxPro application and insert them into an Excel Spreadsheet.
>
>The Excel Spreadsheet probably won't exist but that is negotiable, I may also need to do some formatting.
>
>Would any kind soul suggest a starting point or a general methodology for this.
>
>Many thanks,
>
>Gerry.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform