Excel and an Array Subscript Error

[Reizvoller]

Hello, 

I am making a simple script to read a range of cells in a spread sheet and return the first cell's value. 

Global $sExcelReferencePath = "\refDoc.xls"

Local $oExcel = _Excel_Open()

Local $oWorkBook = _Excel_BookOpen ($oExcel, @ScriptDir&$sExcelReferencePath)

Local $iRowVal = 2

Local $propArray[9] = _Excel_RangeRead ( $oWorkbook , "Sheet1", "A2:I2", 1 )

If isArray ($propArray) = 1 Then
   ConsoleWrite ("yay")
Else
   ConsoleWrite ("Boo")
EndIf

ConsoleWrite ($propArray[0])

When I run this script , it finds the values and confirms that $propArray is an array but when I try to call $propArray[0] I get back "Array variable has incorrect number of subscripts or subscript dimension range exceeded"

Any advice regarding this would be thoroughly appreciated. 

[Reizvoller]

I figured out my error. 

When collecting data from an Excel sheet , even if just a single row, it requires row and column values to designate what portion of the array is to be used/displayed.

So $propArray is actually "$propArray[0][9]" and to reference it is the same. Hope this helps some future novice from making the same error I did

[Danyfirex]

Hi. You don't need to define the array size like Local $propArray[9]= just use Local $propArray=

 

Saludos

 

[Reizvoller]

Greetings! Thank you for the correction.