Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export to EXCEL
Message
From
05/04/2005 11:44:54
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
01/04/2005 19:10:17
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01000912
Message ID:
01001522
Views:
15
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform