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

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
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
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
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
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
+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 It deals with a similar ...READ MORE

answered Jan 13 in Selenium by Karan
• 19,080 points