_wb.setMissingCellPolicy(MissingCellPolicy.RETURN_BLANK_AS_NULL);
HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(inputFile)); workbook.setMissingCellPolicy(Row.CREATE_NULL_AS_BLANK); HSSFSheet sheet = workbook.getSheetAt(0); for(int rowIndex = sheet.getFirstRowNum(); rowIndex < sheet.getLastRowNum(); rowIndex++) { Cell cell=null; Row row = null; previousCell = -1; currentCell = 0; row = sheet.getRow(rowIndex); for(int colIndex=row.getFirstCellNum(); colIndex < row.getLastCellNum(); colIndex++) { cell = row.getCell(colIndex); currentCell = cell.getColumnIndex(); /* Cell processing starts here*/ } }
_wb.setMissingCellPolicy(HSSFRow.RETURN_BLANK_AS_NULL);
_wb.setMissingCellPolicy(MissingCellPolicy.RETURN_BLANK_AS_NULL);
_wb.setMissingCellPolicy(HSSFRow.RETURN_BLANK_AS_NULL);