>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