Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pre-formatted Excel Spreasheet
Message
De
06/04/2004 10:44:48
 
 
À
05/04/2004 12:49:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00892341
Message ID:
00892610
Vues:
18
>My users are entering data into a database application. I would like the application to enter that data into a already pre-generated/created Excel spreadsheet. Is there a way I can print the pre-generated excel spreasheet with the data that's being entered?

Hi Jeffrey,

Having to deal with the same situation over and over again I wrote
tool rep2excel which is posted here in download section.

It is simple (unpolished) library with common automation tasks.
It let you access excel file like 3D matrix and write as easy as

oXl=createobject...
oXl.open_excel('C:\yourdir\yourtemplate.xls')

oXl.make_cell(1,1,3,'Hello')
oXl.make_cell(2,1,3,'There')

oXl.close_excel()


Also it can write whole arrays or tables at given position
draw & paint boxes, format cells etc.

Secondary it have whole reporting mechanisam (class) that (similar to frx)
can output structured (grouped) reports directly to excel and other tyoes of files.

Only problem is that excel OLE automation is slow writing mechanisam and can be kind of 'slow' with biger tables.

In case u hv problem implementing it
you can contact me any time.

Best Regards
Sergio
*****************
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