_ExcelReadSheetToArray not in latest build of Excel.AU3

[MarkMontemuro]

I downloaded the latest version of AutoIT in order to get the enhanced performance _ExcelReadSheetToArray function. I'm reading in large excel sheets to an array to compare data & the earlier versions of this function takes a very long time. According to posts, the latest version 3.3.12 has the new Excel UDF that supposedly fixes this problem. With the latest install, I can't find this function in the file. Any suggestions of where I can download a version that has the fix

[water]

The function has been replaced by function _Excel_RangeRead.

[MarkMontemuro]

Same Input Params as the old & same return values?

[water]

Lot of changes. Please check the help file and the script breaking changes section of the help file.

Edited October 23, 2014 by water

[MarkMontemuro]

Thanks for your help, Will do

[MarkMontemuro]

In the previous call I was able to specify a row/column for my ReadCell  for example; " _ExcelReadCell($oExcel, $iRows,2)".  Can I still use this in the new call _Excel_RangeRead?   I can only find examples using this format _Excel_RangeRead($oExcel,Default,"C2"). I do calculations to read cells from certain offsets, $iRows.

[JLogan3o13]

The examples included in the help file show reading a single cell, a group of cells, and an entire colunm. Can you please specify what you are trying to do that won't work with _Excel_RangeRead? An example that did work in the old would be beneficial.

[MarkMontemuro]

This worked in the previous call

1st Date is:20001030 Last Date is:20141028

using the code below.

ConsoleWrite("1st Date is:"&_ExcelReadCell($oExcel, 3,2)&" Last Date is:"&_ExcelReadCell($oExcel, $iRows,2)&@CRLF)

Question is how do I then use the Row,Col format in _Excel_RangeRead?

[water]

The new Excel UDF only supports A1 notation. R1C1 support has been dropped. But there are functions to translate to/from A1 notation.

[AdamUL]

Here give this a try.  This is a direct translation to show using the new UDF.  Notice that it is using a workbook object, instead of an application object.  

ConsoleWrite("1st Date is:" & _ExcelRangeRead($oWorkbook, Default, _Excel_ColumnToLetter(2) & "3") & " Last Date is:"& _ExcelRangeRead($oWorkbook, Default, _Excel_ColumnToLetter(2) &  $iRows) & @CRLF)

Adam