Log if value not found

Help
1

This may be easy but I dont know how to do this IF.

I loop throught the table and If there is not such value I’m looking for Get Cell Value gives me an error. I need to make an “IF”. If there is not such value then give me log “No value”.

image
image1356×625 22.1 KB

Thank You for Your help.
Marek

2

Add an If activity after the Get cell value activity. The condition should be set to value.ToString = String.Empty. In the Then section of the If activity, add a Log Message or Write Line activity with string "No value".

1 Like
3

Yes, but it gives me the error on “Get cell value” and doesnt go to the “IF” after it :frowning:

4

Get cell value must be in an Excel Application Scope activity opening the workbook with the cell you want to get.

5

I do not use Excel here. I use SAP and SAP activites from UiPrime packages.

6

Have you Tried Using GetText / get Visible Text ?

–
Mukesh