How to find a string inside Excel table

[dotan]

Hi,

I am trying to find a string inside Excel table, and it does not work. Please see attached figure. I use the find Invoke Node and do not get anthing.

Please help

[Khalid]

Hi,

Do you not get anything the Variant indicator?  Any errors?

-Khalid

[dotan]

The variant indictor has nothing and I get error 97 (Unknown System Error in Read_XL.vi). The error is generated at the end of Range->Value2.

[Khalid]

Error 97 is when a Null Refnum is passed in as input.  So, make sure your reference is valid throughout the chai of property/method nodes. 

Also, can you attach the VI?

-Khalid

[dotan]

See attached files.

Thanks,

David

[AESulzer]

The reason for your error is that the search range you are specifying is too narrow. Currently, your search range is set to stop on the 5th row of the worksheet, but the cell that contains the string you are searching for is located on the 6th row. When the Range.Find method doesn't find a match, it returns an invalid reference, which gets passed to the next invoke node and causes this error. Expand your search range to 6 rows, and everything should work just fine. Moreover, you should build some programmatic logic in your VI to handle the case of the search finding no matches so that you can prevent that case from causing an error and taking down the rest of your program.

Kind Regards,