How to capture the value of a text inside the area when there are not found rows

[pprin070 (Paolo)]

Hello, guys.

I need help to capture the value of “No Hay coincidencias”.
I tried using get Text activity but when I selected the area and clicked on “No hay coincidencias” I got

“Could not get element selector data.
Reason: Error HRESULT E_FAIL has been returned from a call to a COM Component”

I tried to close Excel and reopen UiPath and the same error.
I used the option of UI Framework ( F4 ) and didn’t work

What I want to do is to get that text and then try to put an IF sentence with that text, or do you suggest another way ?. Thanks

[postwick (Paul Ostwick)]

You’re trying to work with Excel using UI Automation. That’s generally not how you work with Excel. There are activities specific to Excel that allow you to read the data, analyze it, etc.

DataTables and Excel Automation with Studio (v2020.10)

[Anil_G (Anil Gorthi)]

@pprin070

Looks like ypu are trying to filter and check if any rows are returned

If so read the data into datatable and then use filter datatable activity and check dt.RowCount=0

Cheers