Arrays to variables

[DrewSS]

Hello,

Pretty new here but so impressed... I've been reading the forums for days straight (like all I do all day long till I figure this stuff out) but I am having a hard time grasping what I think should be a simple concept; also just learning to program, and also just learning AutoIT, so hoping a little help can accelerate my knowledge and usage.

Here is the problem:

I'm using _ExcelReadSheetToArray to grab 2 columns of data, and I need to loop column1 rows, and column2 rows as separate variables to use as separate search and output strings to a document. For example, each column has several hundred rows, and I need to do something like setting a dynamic variable for col1 row1 + variable for col2 row1, so I can use $variable1 + $variable2 to perform some tasks.

(The task will be to target "statictext"+$variable1+"."+$variable2 in a folder, then some simple find and replace... )

My main hangup: How would I loop the array column results into dynamic variables so it runs my task for each row? Maybe I'm just not understanding loop and array syntax? 

I would really appreciate any tips, hints, direction, or anything!! Certainly willing to buy someone lunch for the help too! :-D

EDIT: really just trying to understand the dynamic variable/looping from the Array... the task of what to do with the variables I will figure out.

Edited June 18, 2014 by DrewSS

[jchd]

Something like that?

$result = "some text" & $array[$i][0] & $array[$i][1]

You really should take some time studying the wiki page on arrays.

[mLipok]

So here is to facilitate the appropriate link

It is worth a look as it has recently been improved a bit

mLipok

EDIT:

btw.

@DrewSS

Welcome to the forum.

Edited June 18, 2014 by mLipok

[Geir1983]

So your array will have two dimensions, first dimension is the rows and the second is the columns. What you want to do is loop through your array for as many rows you got and do some calculations on each column in that row. See my psuedo code below

For $rows = 0 to Ubound($ExcelArray)
    $ExcelArray[$rows][0] ;This is column 0
    $ExcelArray[$rows][1] ;This is column 1
Next

[jchd]

AutoIt arrays are zero-based, so make that:

For $rows = 0 to Ubound($ExcelArray) - 1

else you'll get more big bang that you'd expect.

[DrewSS]

Wow... I knew it was something simple I wasn't getting! Thank you, everyone, I believe I understand much better now!