_Excel_RangeRead question

[bin123485 0]

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


Local $oAppl = _Excel_Open()

Local $oWorkbook = _Excel_BookOpen($oAppl, @ScriptDir & "\1.xls")

Local $aResult = _Excel_RangeRead($oWorkbook, 1, "A1:C1", 2)
_ArrayDisplay($aResult, "Excel UDF: _Excel_RangeRead Example 2 - Cells A1:C1 of sheet 2")
Local $iData = $aResult[0]

Error Massage:

"E:AU3testtest.au3" (12) : ==> Array variable has incorrect number of subscripts or subscript dimension range exceeded.:

Local $iData = $aResult[0]

Local $iData = ^ ERROR

why is that? $sResult is not an array?

[water 1,936]

If there is no error returned by _Excel_RangeRead then it is an array. In fact a 2D array because you read multiple rows and columns. So you need two index variables to access the content of the array.

[bin123485 0]

If there is no error returned by _Excel_RangeRead then it is an array. In fact a 2D array because you read multiple rows and columns. So you need two index variables to access the content of the array.

yes. it's a 2D array. Thanks.

Another question: I want to get the number of rows in the array $aResult. Ubound($aResult) is 65536. So how can I get the correct number?

Edited August 9, 2014 by bin123485

[water 1,936]

Please check example 3 in the help file for function _Excel_RangeRead. It reads all used cells of a column by using

$oWorkbook.ActiveSheet.Usedrange.Columns("A:A")

Edited August 9, 2014 by water

[bin123485 0]

 

Please check example 3 in the help file for function _Excel_RangeRead. It reads all used cells of a column by using

$oWorkbook.ActiveSheet.Usedrange.Columns("A:A")

It works. Thank you very much.

[water 1,936]