Excel rangeread

[macran]

$ar_array=_ExcelReadSheetToArray($arexcel,2) ;----from 2nd row
$weekly_array=_ExcelReadSheetToArray($weeklyexcel,2,5) ;----from 2nd row and 5th col

how to get the same  effect by use _Excel_RangeRead? thanks!

[l3ill]

Have a look here

The second example shows how to set the parameters to extract to an array.

[water]

Or you could read the whole worksheet and simply ignore the unneeded cells.

Another approach: Example 3 shows how to use the UsedRange object.