Home » Core Java » Selenium Chromedriver Tutorial

About Sarad Dhungel

Sarad Dhungel
I am a graduate in Computer Engineering from Howard University. Third place award winner in Intel-Cornell Cup. Passionate about new emerging software and technology. During free time, I enjoy reading about politics, business, spirituality, technology and traveling.

Selenium Chromedriver Tutorial

 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 by clicking 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:

Project Structure

Project Structure

The excel file “Testdata” contains username and password.




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) {
	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 name
			entry.add(sheet.getRow(i).getCell(1).getStringCellValue()); // password
		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.


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); 
			List<List<String>> data1 = excel.getList();
			for (List credentials : data1) {
			WebElement hello = driver.findElement(By.id("email"));
			WebElement hello1 = driver.findElement(By.id("pass"));

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 as findElement(), sendkeys() and submit(). FindElement() finds the email section of the Facebook URL using ID element and thus sendkeys() method sends username from the spreadsheet to it. Likewise, password section of Facebook page gets password from spreadsheet using sendkeys method.

The implicit 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. The thread.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:

You can download the full source code of this example here: Selenium Chromedriver Tutorial
(No Ratings Yet)
Start the discussion Views Tweet it!

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

Subscribe to our newsletter to start Rocking right now!

To get you started we give you our best selling eBooks for FREE!


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 ....


Receive Java & Developer job alerts in your Area


Leave a Reply

Notify of