How to Read Excel Files Using Apache POI In Selenium WebDriver


Let’s see how to Read excel files using Apache POI in Selenium WebDriver:
Step 1– Download Apache POI jar file
Step 2– Add download jar files to your project build path.
Select Project and Right click on the Project – Go to ‘Build path’ – Go to ‘Configure build path’ – Click on ‘lib’ section – Add external jar

Below mentioned script shows how to read excel files in Selenium using Apache POI.     
import java.io.FileInputStream;
import java.io.IOException;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ReadingExcel {


public static void main(String[] args) throws IOException {


FileInputStream file = new FileInputStream("C://SeleniumPractice/data3.xlsx");

XSSFWorkbook workbook = new XSSFWorkbook(file);
XSSFSheet sheet = workbook.getSheet("Sheet1");

int rownum = sheet.getLastRowNum(); // returns number of rows present in excel sheet

int colcount = sheet.getRow(0).getLastCellNum(); // returns number of cells present in a row

for (int i = 0; i < rownum; i++) {

XSSFRow row = sheet.getRow(i);

for (int j = 0; j < colcount; j++) {

String value = row.getCell(j).toString(); // reading the data from cell
System.out.print(value + " ");
}

System.out.println();


}

}
}

Followers