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.
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();
}
}
}
