1. Introduction

In this example set, we will be exhibiting the concept of Data Driven Testing (DDT) by passing multiple sets of data using Apache POI and Web driver interface of Chrome Driver and thus testing them on the Facebook URL. In this tutorial, we will be passing multiple sets of username and password from spreadsheet “Testdata.xls” to Facebook URL.

I will skip details about configuring Maven, Apache POI API and Selenium Chrome Driver API. Please refer to my previous example byclicking here  to configure them.

Environment of the Project:

1. Selenium Web driver 2.5.0
2. Apache POI 3.15
3. Chrome Driver 2.25
4. Maven 4.0
5. Eclipse Version: Neon Release (4.6.0)
6. JDK 1.6

Project Structure looks like below:

The excel file “Testdata” contains username and password.

ExcelConfiguration.java

package com.javacodegeeks.seleniumexample.SeleniumChromeDriver;import java.io.FileInputStream;import java.util.*;import org.apache.poi.xssf.usermodel.XSSFSheet;import org.apache.poi.xssf.usermodel.XSSFWorkbook;public class ExcelConfiguration {public static XSSFWorkbook wb;public static XSSFSheet sheet;public ExcelConfiguration(String excelPath){try {FileInputStream fis = new FileInputStream(excelPath);wb = new XSSFWorkbook(fis);} catch (Exception e) {System.out.println(e.getMessage());}}public List<List<String>> getList(){sheet = wb.getSheet("Data");List<List> data = new ArrayList<List>();for (int i = 1; i < sheet.getLastRowNum(); i++) { List entry = new ArrayList();entry.add(sheet.getRow(i).getCell(0).getStringCellValue()); // user nameentry.add(sheet.getRow(i).getCell(1).getStringCellValue()); // passworddata.add(entry);}return data; }}

In this Java class, the path of the file has been passed as parameter to the constructor ExcelConfiguration and thus the file is loaded using FileInputStream. The class is surrounded with try/catch block so that if there is any exception, the message will be printed.

Getlist() method contains List of list. The List containing username and password is therefore created to add the row and column from the spreadsheet “Data”. The for loop iterates through every row from column 0 (username) and column 1 (password) until last row reaches and so it adds those into list “entry”. The List “entry” is then added into the main list “data”. Hence by creating this main list, sub list can grow dynamically as more rows and columns are added.

ChromeConfiguration.java

package com.javacodegeeks.seleniumexample.SeleniumChromeDriver;import java.util.List;import java.util.concurrent.TimeUnit;import org.openqa.selenium.By;import org.openqa.selenium.WebDriver;import org.openqa.selenium.WebElement;import org.openqa.selenium.chrome.ChromeDriver;public class ChromeConfiguration {public static void main(String [] args) throws InterruptedException{     ExcelConfiguration excel = new ExcelConfiguration("//Users//saraddhungel//desktop//Testdata.xlsx");String exePath = "/Users/saraddhungel/Downloads/chromedriver";System.setProperty("webdriver.chrome.driver", exePath);WebDriver driver = new ChromeDriver(); driver.manage().timeouts().implicitlyWait(3, TimeUnit.MINUTES); driver.get("https://www.facebook.com/");List<List<String>> data1 = excel.getList();for (List credentials : data1) {WebElement hello = driver.findElement(By.id("email"));hello.sendKeys(credentials.get(0));WebElement hello1 = driver.findElement(By.id("pass"));    hello1.sendKeys(credentials.get(1));   driver.findElement(By.xpath("//*[@id='loginbutton']")).click();Thread.sleep(5000);driver.findElement(By.id("userNavigationLabel")).click(); driver.findElement(By.xpath("//li[12]/a/span/span")).click();  Thread.sleep(5000);}}}

List “data1” is created and as a result geList() method is invoked. For-each credentials list in data1, loop iterates through the list “data1” that contains getlist() method containing list “data” in such a way that credentials.get(0) returns username and credentials.get(1) returns password column.

WebElement interface is implemented to invoke its method such asfindElement(),sendkeys() andsubmit().FindElement() finds the email section of the Facebook URL using ID element and thussendkeys() method sends username from the spreadsheet to it. Likewise, password section of Facebook page gets password from spreadsheet usingsendkeys method.

Theimplicit wait() method helps to better locate the elements by polling the DOM for a certain amount of time. In consequence, 3 minutes of implicit wait time have been used before loading the Facebook URL which is set for the life of the web driver object instance until it changes. Thethread.sleep() method makes the browser wait for 5 second.

After running the project, console shows the following message and therefore it loads the chrome browser.

We can see username and password being iterating through the URL of facebook and also on the console.

2. Conclusion

This example set is an attempt to show the functionality of data driver testing script, where test data are read from data files instead of using the same hard-coded values each time the test runs.

3. Download the Source Code

You can download the full source code of this example here:

Do you want to know how to develop your skillset to become aJava Rockstar?

Subscribe to our newsletter to start Rockingright now!

To get you started we give you our best selling eBooks forFREE!

1. JPA Mini Book

2. JVM Troubleshooting Guide

3. JUnit Tutorial for Unit Testing

4. Java Annotations Tutorial

5. Java Interview Questions

6. Spring Interview Questions

7. Android UI Design

and many more ....

I agree to theTerms andPrivacy Policy

Sign up

Thank you!

We will contact you soon.