Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement