How do I find an icon and click on it in an excel sheet?

Help
1

Hi,

I have an icon in an excel sheet which I need to search and click on it. On clicking this icon, a text box is opened through which we take the input of number of rows to be added at a particular position.

Regards,
Jaideep

2

Is it a button within the workbook? If so, does this button trigger a macro?

3

Yes, it is within the excel sheet and calls a macro.

4

If you know the macro name you should be able to execute the macro with UIPath and ‘simulate’ the button click.

5

It is all password protected. Neither I am allowed to access the macros nor I have the macro names.

6

do it with any image recognition activity like OCR or click image! what’s the problem of use it ?

Regards :mage:

7

I will try and let you know the results.

8

It is not working…

9

Hi @Jaideep

Did you use the Click Image activity @Pablo_Sanchez recommended? Can you share your workflow? We’ll take a look.

Regards
Troy

10

Yes please, share your .xaml so we will be able to take a look

It should be an easy work, so I dont rly get whats hapening

Regards :mage:

11

Does anyone have solution about this case?

My problem:
I have string from excel loop to search in SAP and try to click the found line in SAP table, every time, the searched line show different position in table, it is hard to click by a static position.

br/Colin

12

you should change the selector to find in SAP the exact text that you are reading from excel file.

13

Yes, you are right. This has been validated and passed.

1 Like