For loop and Excel problem.

[flambert95]

Can anyone tell me why this wont work?

#include <IE.au3>

#include <Excel.au3>

#include <Array.au3>

 

$oExcel = _ExcelBookOpen("C:UsersusernameDocumentsautoit.csv", 1)

$products = _ExcelReadSheetToArray($oExcel, 1, 2, 0, 1)

;_ArrayDisplay($products, "Starting on the 2nd Row")

MsgBox(1, "test", "hej")

 

For $product in $products

  MsgBox(1, "test", "works")

Next

 

If I use _ArrayDisplay($products, "Starting on the 2nd Row") It display fine but it wont show MsgBox(1, "test", "works").

 

Can anyone help?

 

Thanks best regards

flambert

[water]

Because _ExcelReadSheetToArray returns a 2D array which can't be processed by For/Next.

According to the help file: "If the expression is an Object collection with no elements, or an multi-dimensional array, the loop will be skipped and the Variable will contain an empty string."

[water]

BTW:

Please enclose your code in AutoIt code tags (the big blue A icon in the editor). Greatly enhances readability

[flambert95]

Is there a way to make a for loop or something like that for it?

[water]

Something like this?

For $iIndex = 1 to $products[0][0]
    ConsoleWrite($products[$iIndex][1] & @LF)
Next