mardi 2 juillet 2019

How to create a loop in selenium web driver that reads value from excel and do repeated actions

I have an excel with 500 urls. Selenium script has to do same actions after clicking each url. That is, after clicking 1st url from 1st cell, script should open that url, then it should locate an element in that url using the id i am mentioning in the second cell. After that it should locate next element in same url using the id from third cell and so on. After all id's are picked up and located from 1st row, script should go to 2nd row in excel.

In second row, 1st cell is URL, followed by ids of elements in subsequent cells. Script should continue the actions until there are no more urls left.

Could someone please provide me an answer on how to achieve this?




Aucun commentaire:

Enregistrer un commentaire