Reading .xls and .xlsx Excel file using Apache POI Java Library

In this example, we will take a look at how to read/parse .xlsand .xlsx Excel files using Apache POI Java Library,

POI Maven Dependency



POI Gradle Dependency

implementation group: 'org.apache.poi', name: 'poi', version: '5.2.2'
implementation group: 'org.apache.poi', name: 'poi-ooxml', version: '5.2.2'

Reading/Parsing Excel file with .xlsx or .xls extension

Sample Excel File:
Sample Excel File Data
Java Code:
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.util.Iterator;

 * Java Program to read a Excel .xlsx or .xls file
public class ExcelReaderPOIExample {

    public static void main(String[] args) {

        String excelFileName = "/Users/code2care/Desktop/Students-Details.xlsx";
        File excelXlsxFile = new File(excelFileName);
        try (FileInputStream fileInputStream = new FileInputStream(excelXlsxFile);

             XSSFWorkbook workbook = new XSSFWorkbook(fileInputStream)) {
             //reading the 1st tab
             XSSFSheet spreadsheet = workbook.getSheetAt(0); 

            for (Row cells : spreadsheet) {

                XSSFRow row = (XSSFRow) cells;
                Iterator<Cell> cellIterator = row.cellIterator();

                while (cellIterator.hasNext()) {
                    Cell cell =;
                    if (cell.getCellType() == CellType.NUMERIC) {
                        System.out.print((int) cell.getNumericCellValue() + "\t");
                    } else if (cell.getCellType() == CellType.STRING) {
                        System.out.print(cell.getStringCellValue() + "\t");
                    } else if(cell.getCellType() == CellType.FORMULA) {
                        System.out.print(cell.getCellFormula() + "\t");
                System.out.println(""); //break the line
        } catch (IOException e) {
            System.out.println("Error occurred while reading Excel file!");

Sr.No Student Name City Age
1 Justin Chicago 23
2 Alex Austin 24
3 Brain New York 21
4 Samantha San Jose 24
5 Tiffany Chicago 23

Facing issues? Have Questions? Post them here! I am happy to answer!

Author Info:

Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail:

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap