Excel_RangeRead

[JenMaughan]

Hi

I know this must be a simple issue, I just don't know the answer - I've tried all variations I can think of. 

 

 I need to read to read cell range A:Q on a SPECIFIED WORKSHEET - this won't be the default open sheet that it is saved to.   Let's say, I need it to open to Parabolas - which is the Title of worksheet 2.   What it does now:  Opens to different worksheet

 

Local $oExcel = _Excel_Open()

Local $sWorkbook = @ScriptDir & "\MathClassExamples.xls"
Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook)

Local $aResult = _Excel_RangeRead($oWorkbook, 2, $oWorkbook.ActiveSheet.Usedrange.Columns("A:Q"), 2)

_ArrayDisplay($aResult, "Parabolas Columns A through Q")

 

[Jfish]

I did a reproducer script/ test and I found that if you save the workbook with tab 2 active it works.  If another tab is active when you save - it does not.   I think the problem may be with the range. In this case an object is being passed as the range and it overrides the second parameter.  Therefore, "activseheet" will go to whatever the book was saved under last - even if the 2nd parameter says something different because that is the activesheet when it opens.

If you if you modify the range object from the example in the help file to this:

$oWorkbook.Worksheets.Item(2).Usedrange.Columns("A:Q")

It seems to work.

@JenMaughan please try that snippet as your third parameter. It should ignore the second parameter and produce the result.

@waterPerhaps you could add a note in the help file suggesting the second parameter will be overridden by a range object?

Edited January 28, 2016 by Jfish

[water]

Or

Local $aResult = _Excel_RangeRead($oWorkbook, Default, $oWorkbook.Worksheets("Parabolas").Usedrange.Columns("A:Q"), 2)

If parameter 3 accesses another worksheet then specified in parameter 2 then parameter 2 will be ignored.

Edited January 28, 2016 by water

[water]

I have added a remark to the help file.
I'm still unsure if an additional example in the help file is needed.