Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to export a report to Excel format ?
Message
From
12/01/2001 18:49:07
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00462811
Message ID:
00463289
Views:
19
>Hi all,
>
>Can anyone know how to export a report to Excel format ?
>
>Thanks,
>
>Samuel

Don't know if this is what you are looking for...

select the fields with the names you want in the excel table:

sele ccusname as customer_name, other_field as field2 etc. ;
from customer ;
into cursor t1

copy to filename.xls type xl5



take a look at the putfile() command for defining the location and name of the resulting excel file.

Hope this helps...
Thanks,

Stacy



Black Mountain Software, Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform