About _Excel_RangeFind() question

[Vencejo]

Hi all,

I think i´m doing something wrong. In the following code, _excel_RangeFind() does not find all occurrences.

From sheet1 to sheet9 it does not find the occurrence of row 1, and on sheet10 it find it, but puts it last.

Where am I wrong?

Thank you very much and sorry for my inglish.

The code:

 

#include <Excel.au3>

Local $oAppl = _Excel_Open(True)
Local $oWorkbook= _Excel_BookNew($oAppl, 10)
Local $namesheet= "hoja";<-- Default name for sheet in spanish language: hoja1, hoja2, hoja3 etc.


For $x= 1 to 10;<-- $x completes the name of the excel sheet: $namesheet & $x
    for $y= 1 to 5
        _Excel_RangeWrite($oWorkbook, $namesheet & $x , "sofia" & " " & $namesheet & $x & " " & $y,"A" & $y)
    Next
Next

Local $search= _Excel_RangeFind($oWorkbook, "sof")
    _ArrayDisplay($search)

This is using 3.3.12 version and office 2007.

Edited March 2, 2017 by Vencejo

[water]

I just tried with AutoIt 3.3.14.2. and Excel 2010 and it works as expected.

Can you please check the values of @error and @extended after calling _Excel_RangeWrite and _Excel_RangeFind?

[Vencejo]

I´m not sure if this is correct.

I write after line _excel_RangeWrite():

ConsoleWrite("Range write error: " & @error & " Extended: " & @extended & @CRLF)

and after line _excel_RangeFind:

ConsoleWrite("Range find error: " & @error & " Extended: " & @extended)

 

In both cases @error and @extended are 0 (zero).

 

 

Edited March 2, 2017 by Vencejo

[water]

When you display the Excel workbook do all the sheets contain the expected data?

[Vencejo]

Yes. Array[40] detect A1data in row 1 only.

Edited March 2, 2017 by Vencejo

[water]

There was a bug in _Excel_RangeFind which has been fixed with version 3.3.13.21.
If you could upgrade to 3.3.14.2 then this bug is gone.

[Vencejo]

Ok thanks.

I had many many problems with 3.3.14 version and excel udf and read that 3.3.12 version solved it (it was true).

I will try 3.3.13 and check it

Thanks a lot!

 

[water]

If you update the 3.3.14.2 version of the Excel UDF with the two fixed functions everything should run fine.

 

[Vencejo]

I already knew the solution proposed in that post, but unfortunately in my case it did not work. Only using version 3.3.12 all excel udf problems completely disappeared.

Thank you for your help.

 

[water]

I tested your script with AutoIt 3.3.14.2 plus the two fixed functions.
The result was as expected.
Which further problems did you notice?

[Vencejo]

Please, give me some days for an exact answer, but problems were not from Excel_RangeFind(), but may be _excel_rangeread and "this is not a object" or something, (I dont remember, sorry) 

I need upgrade to 3.3.14, extract the problematic part of code (it has more of 6000 lines) and upload it. And it is not easy because sometimes its work, sometimes not.

 

Edited March 2, 2017 by Vencejo

[water]

Sure, take all the time you need