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
139 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
• 9,300 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,010 points
52 views
0 votes
1 answer

Selenium ChromeDriver issue - Want to run it in background, but not as headless browser

This is a flaw with ChromeDriver. Tried ...READ MORE

answered Mar 26, 2018 in Selenium by nsv999
• 5,510 points
1,776 views
0 votes
1 answer
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
484 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
1,758 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
1,963 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
• 9,300 points
1,187 views
+4 votes
1 answer

which headless browser automation is good?

To answer your Queries: 1. HTML Unit -  taking ...READ MORE

answered Nov 29, 2019 in Selenium by Karan
• 9,300 points

edited Nov 29, 2019 by Sirajul 152 views