Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel reports
Message
De
27/06/2001 16:27:22
Tom Pickel
Corporate Technology Group
Arlington, Texas, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Divers
Thread ID:
00523238
Message ID:
00524411
Vues:
14
If you are creating reports that are just delimeterd columns, Why not use the SQL Select command using the fields as the column name and then copy to filename.xls type xls? The SQL Query is very usefull for reports.

SELECT ;
Field1 AS Column1, ;
Field2 AS Column2, ;
FROM ;
Table1Name.Field1, ;
Table2Name.Field2, ;
WHERE ;
;
AND ;
OR ;
ORDER BY Field1 ;
INTO TABLE OutputTableName
USE OutputTableName
COPY TO ExcelFile.xls TYPE XLS

The output is a column delimetered Excel Spreadsheet. There is also Excel's COM Server. Which is fairly easy to work with.

Tom
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform