Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Exporting Data To Excel...
Message
De
03/10/2005 02:17:50
 
 
À
30/09/2005 18:17:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01055133
Message ID:
01055419
Vues:
18
Hi Onelio,

You can have look at my 'rep2excel' tool here in downloads.
It is class object having most of common excel writing tasks
wrapped into simple methods calls.

oXl.table_in_section(nSheet,nRow,nCol, cAlias,'field1|field2|...')
oXl.array_in_section(nSheet,nRow,nCol, &MyArray)
oXl.draw_box(nTop,nLeft,nDown,nRight,nColor)
oXl.insert_picture(nSheet,nRow,nCol, cBmpFile)

etc.

If you need to write fully blown reports with grouping,headers,footers etc,
you can try 'CodeRep' which uses the same excel automation to write report to excel file.
Both are free with full source & samples included.

Rgds++
Sergio

>Hello There...
>
> Don't know if this is the place to ask about my doubt/problem, but there it goes...
>
> I want to export my data into a Excel file, but I want the result file to be formatted so I can open it and send it to the printer. How can I give the format to a file via coding so the result excel file will be like I wish?
>
> Thanks in advance...!!!
>
>Onelio
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform