Reading the excel and running multiple URL's in the browser and updating the excel if issue found for those URL's

+2 votes
Task: How can I read and run multiple URL’s one by one from excel in the browser followed by writing/updating the excel if those URL’s has issues.
Jan 21 in Selenium by Gaurav
• 140 points
319 views

1 answer to this question.

+1 vote

Try the following steps:

  • use excel application scope and pass the file path as input

  • inside the scope use read range activity and get the output with a variable of type datatable named dt

  • now use a FOR EACH ROW activity and pass the above variable dt as input

  • inside the loop use a OPEN BROWSER activity and mention the input as row(“yourcolumnname”).ToString

  • So that it will open the url

Inside the mid open browser container we can keep the set of activities to be processed

answered Jan 21 by Karan
• 10,080 points

Related Questions In Selenium

0 votes
1 answer
0 votes
1 answer

What happens if I don't create a Package and add a Class directly under the Project in Eclipse?

Hello Avantika, its not considered as a ...READ MORE

answered Jul 16, 2019 in Selenium by Anvi
• 14,050 points
64 views
0 votes
1 answer

What is the role of TestNG & JUnit frameworks in Selenium?

Well TestNG and JUnit are test frameworks ...READ MORE

answered Apr 18, 2018 in Selenium by king_kenny
• 3,710 points
641 views
0 votes
1 answer

Finding WebDriver element with Class Name in java

The better way to handle this element ...READ MORE

answered Apr 10, 2018 in Selenium by nsv999
• 5,510 points
2,593 views
0 votes
1 answer

Diff between WebDriver listeners and TestNG listeners?

This is not a very important concept ...READ MORE

answered Apr 13, 2018 in Selenium by king_kenny
• 3,710 points
2,160 views
0 votes
1 answer
+1 vote
1 answer

How can I automate the process of adding iPhone to cart in Flipkart using Selenium(java),Page Object Model and TestNG? Also validate if product is added and available in cart?

Hey check this https://www.edureka.co/community/47160/automate-purchase-adding-book-cart-flipkart-using-selenium? It deals with a similar ...READ MORE

answered Jan 13 in Selenium by Karan
• 10,080 points
2,008 views
+1 vote
1 answer

How to get the following-sibling element for a table type of structure

Why do you want to use the ...READ MORE

answered Apr 9 in Selenium by Karan
• 10,080 points
81 views