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, 2020 in Selenium by Gaurav
• 140 points
3,151 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, 2020 by Karan
• 19,610 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 17, 2019 in Selenium by Anvi
• 14,150 points
1,472 views
0 votes
0 answers
0 votes
0 answers
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, 2020 in Selenium by Sri
• 3,190 points
2,797 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,500 points
13,490 views
0 votes
1 answer

Diff between WebDriver listeners and TestNG listeners?

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

answered Apr 14, 2018 in Selenium by king_kenny
• 3,710 points
6,413 views
0 votes
2 answers

Problem while using InternetExplorerDriver in Selenium WebDriver

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

answered Aug 31, 2020 in Selenium by Sri
• 3,190 points
9,030 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, 2020 in Selenium by Karan
• 19,610 points
8,227 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP