Unite
Created by: eduard93
switch (cell.getCellTypeEnum()) {
case FORMULA:
switch (cell.getCachedFormulaResultTypeEnum()) {
case NUMERIC:
if (HSSFDateUtil.isCellDateFormatted(cell)) {
value = new java.sql.Date(cell.getDateCellValue().getTime());
} else {
value = cell.getNumericCellValue();
}
break;
case STRING:
value = cell.getRichStringCellValue();
break;
}
case NUMERIC:
if (HSSFDateUtil.isCellDateFormatted(cell)) {
value = new java.sql.Date(cell.getDateCellValue().getTime());
} else {
value = cell.getNumericCellValue();
}
break;
case STRING:
value = cell.getRichStringCellValue().getString();
break;
case _NONE:
case BLANK:
case ERROR:
// not a null
value = "";
break;
case BOOLEAN:
value = cell.getBooleanCellValue();
}