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

If you know you only have three columns change the innermost loop to:
for i = 1 to 3
   ? oRow.Columns(i).Value
endfor
You can also stop the row iteration when you find the first blank row, otherwise it'll process every possible row in the spreadsheet.
if ( empty( oRow.Columns(1).Value ) )
   exit
endif
>How can I limit the number of columns that are processed. It looks like it is processing over a hundred columns for each row. In reality I only need the first three.
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