Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Formating reports to Excell
Message
De
13/06/1999 12:26:44
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00229149
Message ID:
00229250
Vues:
14
>I don't know in VFP build-in capabilities to export reports to Excel file.
>You know command:
>REPORT FORM RepFileName TO FILE ExpFileName ASCII
>
>It is good idea for future version to have:
>REPORT FORM RepFileName TO FILE ExpFileName WINWORD
>and
>REPORT FORM RepFileName TO FILE ExpFileName EXCEL
>
>I solved this problem with a procedure in which:
>1. analyze report file by opening as table.
>2. create cursor with data, columns of which corresponds to control sources of each field in report file.
>3. Create Excel file with COPY TO.
>

With both WinWord and Excell, you always have the option of using OLE Automation; Word can use .DBF files with no problems, so COPY TO ... TYPE FOX2X will help there, and I guess you already found COPY TO ... TYPE XLS

>Nik
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform