POI 엑셀 셀 타입별로 내용 처리

// 데이트 포맷
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

switch (cell.getCellType()) {
	case HSSFCell.CELL_TYPE_FORMULA:
		str = cell.getCellFormula();
		break;
	case HSSFCell.CELL_TYPE_NUMERIC:
		if (HSSFDateUtil.isInternalDateFormat(cell.getCellStyle().getDataFormat())) {
			str = sdf.format(cell.getDateCellValue());
		} else { // 기타
			str = cell.getNumericCellValue() + "";
		}
		break;
	case HSSFCell.CELL_TYPE_STRING:
		str = cell.getStringCellValue() + "";
		break;
	case HSSFCell.CELL_TYPE_BLANK:
		value = cell.getBooleanCellValue() + "";
		str;
	case HSSFCell.CELL_TYPE_ERROR:
		str = cell.getErrorCellValue() + "";
		break;
}​

참고 사이트 

http://www.gnujava.com/board/article_view.jsp?article_no=8297&menu_cd=16&idx_notice=NOTICE_FLAG+DESC%2C&board_no=3 

GNUJAVA