Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import MEMO fields from Excell xls files
Message
From
25/04/2002 13:23:59
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00649136
Message ID:
00649211
Views:
8
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform