public boolean isEmptyRow(Row row){
if(row == null || row.toString().isEmpty()){
return true;
}else{
Iterator<Cell> it = row.iterator();
boolean isEmpty = true;
while (it.hasNext()){
Cell cell = it.next();
if(cell.getCellTypeEnum() != CellType.BLANK){
isEmpty = false;
break;
}
}
return isEmpty;
}
}
cell = row.getCell(colNum);
if (cell == null) {
}
else{
if(cell.getCellTypeEnum() == CellType.NUMERIC) {
val = new BigDecimal(new Double(cell.getNumericCellValue()).toString());
val = new Double(cell.getNumericCellValue()).intValue();
}
else if(cell.getCellTypeEnum() == CellType.STRING) {
val = cell.getStringCellValue();
}
else if(cell.getCellTypeEnum() == CellType.BLANK) {}
}