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
753 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
• 19,080 points

Related Questions In Selenium

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,110 points
108 views
0 votes
2 answers

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

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

answered Sep 4 in Selenium by Sri
• 2,970 points
894 views
0 votes
2 answers

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,520 points
3,829 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,544 views
0 votes
2 answers

Problem while using InternetExplorerDriver in Selenium WebDriver

enable trusted connection  in internet explorer by ...READ MORE

answered Aug 31 in Selenium by Sri
• 2,970 points
4,810 views
+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
• 19,080 points
2,754 views