Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automação Excel
Message
From
24/04/2002 19:56:56
Alex Feldstein
Florida, United States
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Re: Automação Excel
Miscellaneous
Thread ID:
00648905
Message ID:
00648935
Views:
21
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform