Need a help in Excel UDF (_Excel_RangeWrite)

[Paranthaman]

Hi Everyone,

I am a beginner and I am currently learning and practicing what Autoit can do, so kindly pardon if it sound's silly.

What my program does ----> I had written a program where I have a FOR (i=0 to n) loop which is running for n times. Inside the FOR loop, contents of array is written into excel using _Excel_RangeWrite .

_Excel_RangeWrite($oExcelDoc, $oExcelDoc.Activesheet, $arrayname, "A1")

Problem ------> During every loop run the contents of column A is only altered

What i intend to do ------> For every loop run (i=0,1,2,3...) I want to write the array contents into respective next adjacent excel columns

i.e) For i=0 loop, every array content should be written in A Column of excel

For i = 1 loop, every array content should be written in B Column of excel.

 

Can anyone give me an idea of  how can i do this? Thanks 

[Jfish]

If I understand you correctly the last parameter of that function will transpose the results horizontally - but it has limits on the size as noted in the help file.  It is the $bForceFunc parameter.

 

[Subz]

You can also transpose your array for example:

#include <Array.au3>
#include <Excel.au3>

Local $aArray[26] = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z']
$oExcel = _Excel_Open()
$oWorkbook = _Excel_BookNew($oExcel)
;~ Write Rows
_Excel_RangeWrite($oWorkbook, $oWorkbook.ActiveSheet, $aArray, 'A1')
_ArrayTranspose($aArray)
;~ Write Columns
_Excel_RangeWrite($oWorkbook, $oWorkbook.ActiveSheet, $aArray, 'A1')