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