Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to send values to an Excel Spreadsheet
Message
De
07/01/1999 17:03:10
 
 
À
07/01/1999 16:52:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Fonctions Windows API
Divers
Thread ID:
00173811
Message ID:
00173817
Vues:
28
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform