Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Paste Excel column of values into grid column?
Message
De
10/07/2003 04:59:52
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00808554
Message ID:
00808769
Vues:
14
>I had originally posted this question in another thread that dealt with the same topic in the reverse direction, so thought I'd reattempt as a new thread. :)
>
>I would like to paste a column of values from Excel into a VFP grid column. Does anyone know if this is easily accomplished? It does not appear that _CLIPTEXT knows how to handle this so I can't parse the copied Excel cells.
>
>Laterness,
>Jon

Jon,
_cliptext has data in TAB delimited format. Save it to a temp file, append to a cursor and process as you want. ie:
lcTemp = sys(2015)+'.tmp'
StrToFile(_cliptext,lcTemp)
select myFieldA from gridRecSource where .f. into cursor crsTemp readwrite
append from (lcTemp) type delimited with tab
erase (lcTemp)
* update gridRecordSource from cursor
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform