Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report Form to Excel Workbook
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00144774
Message ID:
00144856
Vues:
18
>We have a rather complex report that the customer would like to see and manipulate via an Excel spreadsheet. Is there any way to redirect the output to a spreadsheet? We have worked some with reporting to ASCII, but the results were less than favorable.
>
>Thanks!

Daryl, you may find it simpler to send the data source for your report (a cursor, I hope) to and XLS file. Then you can open Excel with Ole Automation, format the data and let the customer have it.

If you need the specific commands to format the sheet the way you want, start a macro, do the formatting and read the results. Most of the commands can be copied directly into VFP.

Barbara
Barbara Paltiel, Paltiel Inc.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform