Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel com integration - can this be achieved with vfp8
Message
From
07/10/2002 10:16:22
 
 
To
05/10/2002 08:30:24
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00708057
Message ID:
00708357
Views:
8
>Hi all vfp8 beta-testers (lucky you)
>
>We use vfp-to-excel integration a lot...
>Everything is ok except that we can run:
>
>1) oExcel.sheets(1).cells(1,1).value = myfoxvalue
>but found no way to run:
>2) oExcel.sheets(1).range("A2:A100") = myfoxarray

Hi there :-))
You can see my class at download section here:
REP2EXCEL
Rep2Excel Exporting/Writing/Reporting to Excel

It can write array with code like this;
this.array_in_section(1,20,10,@myfoxarray)
Which will write whole array as block that starts at
1st sheet, 20th row and 10th column.

Maybe you can find some use of it.
Writing does not use DataToClip() - but writes cell by cell.
In next version will hv 'silent mode' for suppressing messages, wait windows
etc.

Hope this helps you.
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