Selenium - Data Driven using Excel


While designing a test, parameterizing the tests is inevitable. We will make use of Apache POI - Excel JAR's to achieve the same. It helps us read and write into Excel.

Download JAR

Step 1 − Navigate to the URL - and download the ZIP format.


Step 2 − Click on the Mirror Link to download the JAR's.


Step 3 − Unzip the contents to a folder.


Step 4 − Unzipped contents would be displayed as shown below.


Step 5 − Now create a new project and add all the 'External JARs' under 'poi-3.10.FINAL' folder.


Step 6 − Now add all the 'External JARs' under the 'ooxml-lib' folder.


Step 7 − Now add all the 'External JARs' under the 'lib' folder.


Step 8 − The Added JAR is displayed as shown below.


Step 9 − The Package Explorer is displayed as shown below. Apart from that, add 'WebDriver' related JAR's



For demonstration, we will parameterize the percent calculator test.

Step 1 − We will parameterize all the inputs required for percent calculator using Excel. The designed Excel is shown below.


Step 2 − Execute all the percent calculator functions for all the specified parameters.

Step 3 − Let us create generic methods to access the Excel file using the imported JARs. These methods help us get a particular cell data or to set a particular cell data, etc.

import org.apache.poi.xssf.usermodel.*;
public class ExcelUtils {
   private XSSFSheet ExcelWSheet;
   private XSSFWorkbook ExcelWBook;
   //Constructor to connect to the Excel with sheetname and Path
   public Excelutils(String Path, String SheetName) throws Exception {
      try {
         // Open the Excel file
         FileInputStream ExcelFile = new FileInputStream(Path);
         // Access the required test data sheet
         ExcelWBook = new XSSFWorkbook(ExcelFile);
         ExcelWSheet = ExcelWBook.getSheet(SheetName);
      } catch (Exception e) {
         throw (e);
   //This method is to set the rowcount of the excel.
   public int excel_get_rows() throws Exception {
      try {
         return ExcelWSheet.getPhysicalNumberOfRows();
      } catch (Exception e) {
         throw (e);
   //This method to get the data and get the value as strings.
   public String getCellDataasstring(int RowNum, int ColNum) throws Exception {
      try {
         String CellData =
         System.out.println("The value of CellData " + CellData);
         return CellData;
      } catch (Exception e) {
         return "Errors in Getting Cell Data";
   //This method to get the data and get the value as number.
   public double getCellDataasnumber(int RowNum, int ColNum) throws Exception {
      try {
         double CellData =
         System.out.println("The value of CellData " + CellData);
         return CellData;
      } catch (Exception e) {
         return 000.00;

Step 4 − Now add a main method which will access the Excel methods that we have developed.

public class xldemo {

   public static void main(String[] args) throws Exception {
      ExcelUtils  dd = new ExcelUtils ("C:\\Book1.xlsx","Sheet1");
      System.out.println("The Row count is " + dd.excel_get_rows());

      dd.getCellDataasnumber(1, 1);
      dd.getCellDataasnumber(1, 2);
      dd.getCellDataasnumber(1, 3);
      dd.getCellDataasnumber(2, 1);
      dd.getCellDataasnumber(2, 2);
      dd.getCellDataasnumber(2, 3);
      dd.getCellDataasnumber(3, 1);
      dd.getCellDataasnumber(3, 2);
      dd.getCellDataasnumber(3, 3);



Upon Executing the script, the output is displayed in the console as shown below.

Selenium IDE 157