You can use this to compare value CellType if(cell.getCellTypeEnum() = CellType. To get the CellType CellType getCellTypeEnum(), where the CellType is the enum describing the type of the cell. We will be iterating all the cells of the current row Iterator cells = row.cellIterator() Ĭells can be numeric, formula-based, string-based (text) or Blank cell. You may check out the related API usage on the sidebar. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. We will iterate all the rows in the sheet Iterator rows = sheet.rowIterator() These examples are extracted from open source projects. XSSFSheet sheet = workbook.getSheet('Sheet1') We will pass the name / index of the sheet which starts from '0'. Will get the workbook instance for XLS and takes excel file to read XSSFWorkbook workbook = new XSSFWorkbook(XlsxFileToRead) To read an Excel 2007 (.xlsx) we need to use XSSF (XML SpreadSheet Format) and we will use the below classes to work with xlsx files by importing the below statements import .usermodel.XSSFCell This project mirrors the files on which has been known to go down on occasion.

Where as Apache POI supports both xls and xlsx file formats. JExcelApi is a java library which provides the ability to read, write, and modify Microsoft Excel spreadsheets. It only supports the old BIFF (binary) '.xls' format. As we know the main difference with Java JXL which does not support the Excel 2007 '.xlsx' file format.

Jxl api read xlsx file