Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing a spreadsheet-like HTML file
Message
From
20/09/2006 04:52:49
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01155024
Message ID:
01155399
Views:
25
>>>>>>>Is it possible to import an HTML file, in a spreadsheet-like format, directly into a VFP table? It's not in the syntax of VFP7's import or copy

Hi Terry,

There is one method that got very popular with my users
that might work well in this case.

- I show ordinary VFP form with large editbox field (memo).
- User select/copy specific area of interest within excel file
(That wld be desired excel area within HTML page)
- User then paste entire selected content into that editbox/memo
- Then he/she press ok or cancel
* * *
- After that copy/paste being done, all this content becomes one big multiline string which I chop consecutively into lines [with alines() ] and then process line by line. Since cells are separated by tab or something like that, I use it to further chop each line string into array and then
parse those line-array elements into respective fields.

Since there is no Automation involved it is very fast and very easy for users (comes down to copy/paste for them).

HTH
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform