Reading Excel cells

[nsaeidi]

Hi!

I use attached code to read excel cells into arrays, but it  mislocates rows and columns. for example I have this information in excel:

 

0 0 0

1 1 1

2 2 2

I want the code shows  me:

(0,0)=0

(0,1)=0

(0,2)=0

(1,0)=1

(1,1)=1

(1,2)=1

(2,0)=2

(2,1)=2

(2,2)=2

But it shows:

(0,0)=0

(0,1)=1

(0,2)=2

(1,0)=0

(1,1)=1

(1,2)=2

(2,0)=0

(2,1)=1

(2,2)=2

I thought it would work if I  change this part:

Local $s = ""
        For $x = 0 To UBound($aArray, 1)-1
            For $y = 0 To UBound($aArray, 2)-1
                $s = $s & "(" & $x & "," & $y & ")=" & $aArray[$x][$y] & @CRLF
            Next
        Next
        MsgBox($MB_SYSTEMMODAL, "Excel Data Test", "Debug information: Read Cell contents: " & @CRLF & $s)

to

 

Local $s = ""
        For $x = 0 To UBound($aArray, 2)-1
            For $y = 0 To UBound($aArray, 1)-1
                $s = $s & "(" & $x & "," & $y & ")=" & $aArray[$x][$y] & @CRLF
            Next
        Next
        MsgBox($MB_SYSTEMMODAL, "Excel Data Test", "Debug information: Read Cell contents: " & @CRLF & $s)

I also tried to dislocate x and y but it didnt work!

I would really appriciate if anyone can help me with it.

Thanks in advance!
 

ExcelDataTest.AU3

[water]

Works as designed. That's the way Excel returns a range.

I suggest to use the Excel UDF that comes with AutoIt. If you run AutoIt 3.3.12.0 or later then function _Excel_RangeRead will do what you want. Please have a look at the example _Excel_RangeRead.au3.