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

You can automate Excel to open the file and process it cell by cell from inside VFP.
oExcel = createobject( "excel.application" )
oExcel.Visible = .t.

oWorkbook = oExcel.Workbooks
oWorkbook.Open( "TheSpreadsheet.xls" )

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 have a situation where I have data that comes to me in xls files. One of the colums can be very wide. In excess of 3000 characters.
>
>I have setup a table to append this data with that field being a memo field. When I append the xls file, the memo field is empty.
>
>Is there some better way to get the data into Fox table other than the append from command.
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