Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pre-formatted Excel Spreasheet
Message
From
06/04/2004 10:44:48
 
 
To
05/04/2004 12:49:11
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00892341
Message ID:
00892610
Views:
19
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform