| | |
| | | */ |
| | | private Boolean cellNullCheck (Cell cell) { |
| | | if (cell != null ) { |
| | | if (cell.getCellType() != Cell.CELL_TYPE_BLANK) { |
| | | if (cell.getCellType() == Cell.CELL_TYPE_STRING && cell.getStringCellValue() != null) { |
| | | int cellType = cell.getCellType(); |
| | | if (cellType < Cell.CELL_TYPE_BLANK) { |
| | | if (cellType == Cell.CELL_TYPE_STRING) |
| | | { |
| | | if (cell.getStringCellValue() != null) |
| | | return false; |
| | | } else { |
| | | return false; |
| | | } |
| | | } |
| | |
| | | boolean isNull = cellNullCheck(cell); |
| | | |
| | | String cellStr = ""; |
| | | |
| | | if (!isNull) { |
| | | cellStr = CommonUtil.convertExcelStringToCell(cell); |
| | | |