Sign in to follow this  
Followers 0
nsaeidi

Reading Excel cells

2 posts in this topic

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

Share this post


Link to post
Share on other sites



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.

1 person likes this

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0