General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only