Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help - How Read Excel cells to VFP
Message
De
19/06/2001 22:42:00
Peter Wagner
Point Informática Ltda.
Limeira, Brésil
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Help - How Read Excel cells to VFP
Divers
Thread ID:
00521266
Message ID:
00521266
Vues:
48
I'm working with Excel spreadsheet and must READ a Range of values from
cells to import those values to VFP.

I know that the Column range always goes from cell D15 to L15,(this case)
But the number of columns can vary from 1 row to more than 4000 rows.

Question: How can I define the Range in this case, so I could pass
the contents off all cells to VFP/Or how can I know the number os rows
for a range, then its always relative the number of rows it will have.

Does this kind of code also work with non continuos range ?
oRange = oExcel.ActiveSheet.Range("x:y")
FOR nRow = 1 TO oRange.Rows.Count
FOR nColumn = 1 TO oRange.Columns.Count
? oRange.Cells[nRow, nColumn].Value
ENDFOR
ENDFOR

Please help !!

Thanks in Advance.
Peter
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform