Compare the data in the excel file with browser page if its equal it should click the link for each row

Help Activities
, ,
1

Can any one help

2

Can u explain the scenario @Tharusha_Fernando

Regards

Nived N

1 Like
3

@NIVED_NAMBIAR thank you for your help

1 Like
4

i have a excel data table with some data rows(example -community(23)-HNB-2019)
and also a webpage with some links with the same names which is in the the data rows
i need to find the equal name from webpage and go to the link @NIVED_NAMBIAR
can you help

Captureg
Captureg1531Ă—572 62.9 KB

5

Hi @Tharusha_Fernando

  1. Read the Excel file and store in dt1
  2. Use for each row to loop through each row of dt1
  3. Inside for each row use click activitiy to click on link by making it as dynmaic selector using each link

Hope you got it

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed:

6

what if some times the excel file data differs from link name but its still same how can the bot know it and select it

7

Hi @Tharusha_Fernando

If it almost similar then u can use fuzzy selector for the click activity

For more details about fuzzy selctor

Use this link

Hope it helps

Mark it as solution if it able to solve your issue

Regards

NIVED N :robot:

Happy Automation :relaxed::relaxed: