cant foreach sheetlist array

[vkrisz81]

hello, i have newer bug

i make a sheet list by excel_sheetlist

i can list it by arraydisplay

but if i want walk through by for i cant it says out of range.. i mean HOW????????????????????????

14 sheets available

i cant refer to $asheets[4] forexample WHY?????????????

thanksyou

[mLipok]

For $oSheet In $oSheetList
   $oSheet.SomeMethod

Next

 

[vkrisz81]

the problem was this is a 2dimensional array not one.. :S

thanks you

[mLipok]

modified helpfile example

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

; Create application object and open a workbook
Local $oExcel = _Excel_Open()
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_SheetList Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
Local $oWorkbook = _Excel_BookOpen($oExcel, @ScriptDir & "\Extras\_Excel2.xls")
If @error Then
    MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_SheetList Example", "Error opening workbook '" & @ScriptDir & "\Extras\_Excel2.xls'." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
    _Excel_Close($oExcel)
    Exit
EndIf

; Display a list of all worksheets for a specific Workbook
Local $aWorkSheets = _Excel_SheetList($oWorkbook)
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_SheetList Example 1", "Error listing Worksheets." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
_ArrayDisplay($aWorkSheets, "Excel UDF: _Excel_SheetList Example 1")


For $IDX = 1 To UBound($aWorkSheets) -1
    ConsoleWrite($aWorkSheets[$IDX][0] & @CRLF) ; COL 0
    ConsoleWrite($aWorkSheets[$IDX][1] & @CRLF) ; COL 1
Next

 

[vkrisz81]

thanks you, thats ok and clear to me now.