Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import MEMO fields from Excell xls files
Message
De
25/04/2002 13:23:59
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00649136
Message ID:
00649211
Vues:
9
David,

I tried the example that you sent as:

m_xlsfile = getfile('xls')
oExcel = createobject( "excel.application" )
oExcel.Visible = .t.

oWorkbook = oExcel.Workbooks
oWorkbook.Open( m_xlsfile )

oSheet = oExcel.ActiveSheet

for each oRow in oSheet.Rows
?? '.'
with oRow
for each oCol in oRow.Cloumns
? oCol.Value
endwith
endwith
endfor

oWorkbook.Close()
oExcel.Quit()


I get a nesting error on the row
for each oRow in oRow.columns

It dows open Excel and show the data
Am I missing something obvious?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform