Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Controlling Excel from within VFP
Message
De
12/12/2001 13:58:53
Kam Lee
SUNY-Health Science Center
Brooklyn, New York, États-Unis
 
 
À
12/12/2001 07:50:03
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00593112
Message ID:
00593423
Vues:
23
>>Hi all,
>>
>>Where can I find a complete obect model for MS Excel? I like to manipulate
>>Excel from within VFP like opening an existing spreading sheet, retrieving
>>cells' value and etc...
>>
>>Or anybody can give a few pinters to get me started ?
>>
>>Thanks.
>>
>>Kam.
>
>What I usually do is save a macro in Excel, for whatever I plan to do (say, bold, borders, change column width, etc.). The commands can then easily be adapted to VFP.
>
>The following primitive sample may help you get started:
>
>
>oExcel = CreateObject("Excel.Application")
>oExcel.Visible = 1   && for debugging
>oExcel.Workbooks.Add()
>oSheet = oExcel.ActiveSheet
>oSheet.Cells(1,1) = "Hello!"
>
>
>Afterwards, use the "macro" approach.
>
>HTH, Hilmar.

Hi Hilmar,

Thanks for the tip. By any chance you know how to open an existing Excel
worksheet ?

Thanks again.

Kam.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform