Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 6 table to Excel
Message
 
To
18/09/2002 00:54:07
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00701619
Message ID:
00701712
Views:
18
>I need to create some reports files in VFP6 that would load
>in Excel as a sheet, but i also need some formating. I
>tried at first CSV. It did preaty well, but no formating
>allowed. Then i discorved that SLK allows some formating.
>So i need to learn how to produce an Excel sheet in SLK
>format. Anyone knows where I can find information about the
>structure of this type of file?

Not quite sure what do you mean, "create reports ... and some formatting".
But below are few ideas you could find useful.
1. There are free products that allow you to convert VFP report to Excel.
See download section here, for instance.
2. If you need to copy table to Excel and then make cell/columns/header formattings, you can /copy to ...XLS/ and then use Excel Automation.
3. You can /copy to ...SYLK/ to create SLK file directly from VFP table.
4. You can create SYLK file from XLS file using SAVEAS(Output_filename, 2) function in Excel Automation.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform