Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using Excel with Vfp 6.0
Message
De
30/08/2000 08:57:26
 
 
À
30/08/2000 08:12:50
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00410661
Message ID:
00410674
Vues:
15
>I have a application that the user needs to store their records in the same excel file. Is there a way to just appen records to excel?

You can use Excel's automation server to manipulate Excel worksheets to your heart's content; it's the best bet in this situation, where you don't know the ultimate size of the Excel sheet (VFP runs into trouble creating XLS files with >16K recs) and the automation engine can work with spreadsheets that are other than simple tabular layouts; manipulating XLS files with > 1 worksheet in them, or that have formulas, etc.

If you're unsure about how to manipulate the Excel automation model, there have nbeen lots of articles in FoxTalk and FPA on it, and there's a book out on using the Office Automation services in VFP by Della Martin and Tamar Granor from Hentzenwerke Publishing which might help (it doesn't deal with the really difficult issues of automation, but covers the basic issues of Office Automation for VFP.)

Time to put our tax dollars to work in a useful way...
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform