array size

[krishpun]

How to find number of elements present in an array?

I have assigned the output of _ExcelReadSheetToArray($mappingexcel,1,1,0,0,1) to $mappingexcelarray

$mappingexcelarray =_ExcelReadSheetToArray($mappingexcel,1,1,0,0,1)

Now, I want to know how many elements are present in this array?

Can you please help?

regards,

Krishna

[JohnOne]

$numElements = Ubound($mappingexcelarray)

[Melba23]

krishpun,

From the Help file for _ExcelReadSheetToArray:

"Returned array has row count in [0][0] and column count in [0][1]"

So a bit of simple arithmetic will give you the number of spaces in the array that are available for data.

If you want to know how many of those spaces actually hold data, then you will need to set up 2 nested loops and check each element in turn - along these lines:

; Zero the count
$iCount = 0
; For each row
For $iRow = 1 To $aArray[0][0]
    ; And for each column in the row
    For $iCol = 1 To $aArray[0][1]
        ; Increase the count if the element is not empty
        If $aArray[$iRow][$iCol] <> "" Then $iCount += 1
    Next
Next
; $iCount now holds the number of elements in the array which hold data

M23