I am trying to find the text on Web Page from the spreadsheet and after finding the exact title on the web page the bot needs to click on the Select button in a respective row.
Can anyone please advice how to achieve this process for each row in Spread Sheet.
webctrl id =‘ctl00_ctl00_contentHolderMainContent_contentHolderMainContent_AQ*’ tableRow=‘“+tableRowCount+”’ tag=‘A’
I would loop through the dataTable until row(“Title”).contains(“Provision…”)
At first loop your rowCount would be 1. Then next one it will be 2.
So all you have to do is to make is a variable which saves the current Row Count and then you pass this into the selector.
Have a look at this one.
I found a table on Amazon and found out that the selector for each row was either result_0 or result_1 etc.
So in order to press the correct link, I just passed the rowCount variable to the selector.
It might not run on your computer because I made a static example on a predefined site. But the logic should be reusable.
Edit: Don’t mind the activities that aren’t connected. I forgot to delete them.