Guys,

this should be easy as pie one should think.
I was used to write my arrays horizontally (Rowwise) to my Excel log files, but then came the need to do that Vertically (Columnwise) as for the huge amount of data. So I thought this would be as braindead as the horizontal write and could be done with .Range.Value.

Wrong !

The following sample writes only the first item of the Array 20 times

Code:
break on

$file = @scriptdir + '\test.xls'
if exist($file) del $file endif

global $Array[19] ;20 elements !!

for $i = 0 to ubound($Array)
    $Array[$i] = "Item " + $i
next

$xl = createobject("Excel.Application")
$_ = $xl.WorkBooks.Add
$xl.Range("A2:A"+(ubound($Array)+2)).Value = $Array ;Range should translate to A2:A21 = 20 cells
$_ = $xl.ActiveWorkbook.SaveAs("$file")
$xl.UserControl = 1
$_ = $xl.quit


exit 1


Anyone knows how to accomplish that ?
_________________________