Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import MEMO fields from Excell xls files
Message
 
 
To
25/04/2002 13:23:59
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00649136
Message ID:
00649220
Views:
12
Alan,

Sorry, I typed that on the fly... one of those endwiths shoulda been an endfor. It's corrected below
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
      endfor
   endwith
endfor

oWorkbook.Close()
oExcel.Quit()
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform