Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report Form to Excel Workbook
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00144774
Message ID:
00144856
Views:
17
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform