Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting data to formatted EXCEL
Message
From
04/07/2003 04:24:05
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00806875
Message ID:
00806883
Views:
11
>Hi guys...
>
>I have this kind of problem..
>I already have a formatted EXCEL with the line, border even a formula..
>but my difficulty is to enter the value in a column that i've to export from VFP table...
>
>Can any body help me about this...
>
>thx

See in download section here
tool called 'rep2excel'
You will hv to search for it by name since it
is published last year.

It can write excel into excel sheet as it is
2dim array as simple as ;

oXL.make_cell(1,3,3,'Writing')
oXL.make_cell(1,3,4,'is')
oXL.make_cell(1,3,5,'easy')

Or exporting whole tables or arrays like
oXl.table_in_section(1,5,5, 'MyTable' , 'field1|field2|field3' )

There are many more usefull automation calls wrapped together
in one class library.

I made it for this purpose solely - filling up predefined excel sheets.

Hope it will help you

Rgds++
*****************
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