Required jar files, which you can download from Internet. xmlbeans-2.3.0.jar dom4j-1.1.jar poi-ooxml-schemas-3.6.jar poi-ooxml-3.6.jar poi-3.6.jar import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFCell; import org.apache.poi.xssf.usermodel.XSSFRow; import java.util.Iterator; import java.io.*; public class ExcelFileReader { public void ReadSheet() throws Exception { String filename = "c:\\test.xlsx"; FileInputStream fis = null; try { fis = new FileInputStream(filename); XSSFWorkbook workbook = new XSSFWorkbook(fis); XSSFSheet sheet = workbook.getSheetAt(0); Iterator rows = sheet.rowIterator(); int number = sheet.getLastRowNum(); System.out.println(" number of rows" + number); while (rows.hasNext()) { XSSFRow row = ((XSSFRow) rows.next()); Iterator cells = row.cellIterator(); while (cells.hasNext()) { XSSFCel