Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Export to EXCEL
Message
De
05/04/2005 11:44:54
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
01/04/2005 19:10:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01000912
Message ID:
01001522
Vues:
14
>Hello,
>
>I am using VFP8 - is there a way to export to excel and not include the
>field names in the first record?

My trick is to use _Vfp.datatoclip(,,3), trim the first line before pasting:
	_vfp.DataToClip(,,3)
	_cliptext=Strtran(_cliptext, Mline(_cliptext,1)+CR,"")
then in oExcel (yes, automation) I select target range, and then
oExcel.selection.PasteSpecial()
This is very fast, compared with other automation techniques. Note that it won't work for memo fields - you'd have to set them afterwards, cell by cell.

>Also, is there a way to export to multiple sheets in Excel?

Using the above trick, you can select any sheet, and paste into it.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform