Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing a spreadsheet-like HTML file
Message
De
20/09/2006 04:52:49
 
 
À
19/09/2006 10:54:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01155024
Message ID:
01155399
Vues:
29
>>>>>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform