Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Automação Excel
Message
De
24/04/2002 19:56:56
Alex Feldstein
Floride, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Re: Automação Excel
Divers
Thread ID:
00648905
Message ID:
00648935
Vues:
22
>Mais específica, tenho uma planilha excel com conteudo (cabeçalho, valores nas células), quero fazer um programa em VFP para gravar um valor em uma determinada célula desta planilha.

Algo como:
oExcel = CreateObject("Excel.Application")
oExcel.SheetsInNewWorkbook = 1
oWorkBook = oExcel.Workbooks.Add
oExcel.Visible=.t.   && opcional
oRange = oExcel.ActiveSheet.Range("A1:B1")
oRange.Cells[1,1] = "ABC"
oRange.Cells[1,2] = "123"


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform