Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel com integration - can this be achieved with vfp8
Message
De
07/10/2002 10:16:22
 
 
À
05/10/2002 08:30:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00708057
Message ID:
00708357
Vues:
9
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform