Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to automate Excel cell value update
Message
De
13/09/2005 03:49:31
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01048875
Message ID:
01049040
Vues:
20
Hi Edgar,
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, leting you write excel file as u wld write 3d array.

Belowe method call , after excel wrapper class has been instantiated
wld do task you mentioned;

oXl.make_cell(1 ,9 ,1 , DATE(1990,01,01) )
*lParameters nSheet,nRow,nCol , YourValue

There are many other calls for writing entire tables into specific section of excel sheet , arrays , delimited strings, drawing boxes, painting areas
seting formulas etc.
.
oXl.table_in_section(2,10,10 , MyTable)
oXl.array_in_section(3,10,10 , @MyArray)
.
etc.

If you want to write fully blown report in code (with grouping, headers footers etc) then you could also see/use 'CodeRep' tool which also uses the same excel driver to produce excel ouput.

Both downloads are free / shipped with full source code and samples.

Rgds++
Sergio
*****************
Srdjan Djordjevic
Limassol, Cyprus

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

Click here to load this message in the networking platform