Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Automação Excel
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00648905
Message ID:
00648955
Vues:
26
This message has been marked as a message which has helped to the initial question of the thread.
>Alex, este exemplo cria uma nova planilha estou tentando gravar um valor em uma célula de uma planilha gravada anteriormente, localizada em uma determinada pasta.

AAARRGGHH!

Sorry. Esse exemplo era para outra resposta nos newsgroups. Eu fiz copy and paste com erro!

Algo como:
oExcel = CreateObject("Excel.Application")
oExcel.Visible = .T.  && opcional
oWorkbook = oExcel.Workbooks.Open("test.xls")
oRange = oExcel.ActiveSheet.Range("A4:B6")
FOR nRow = 1 TO oRange.Rows.Count
  FOR nColumn = 1 TO oRange.Columns.Count
    ? oRange.Cells[nRow, nColumn].Value
  ENDFOR
ENDFOR
:)


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