Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP 6 table to Excel
Message
 
À
18/09/2002 00:54:07
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00701619
Message ID:
00701712
Vues:
19
>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
Fil
Voir

Click here to load this message in the networking platform