【无标题】java excel导入判断单元格

public String getCellFormatValue(Cell cell,String str ){
		if(cell == null){
			return "";
		}
		String cellValue = "";
		switch (cell.getCellType()) {
		case Cell.CELL_TYPE_STRING:
			cellValue = cell.getRichStringCellValue().toString();
			break;
		case Cell.CELL_TYPE_NUMERIC:
			if(HSSFDateUtil.isCellDateFormatted(cell)){
				Date dates = cell.getDateCellValue();
				if(str.equals("hours")){
					cellValue = dates.getHours() + ":" +dates.getMinutes();
				}else{
					SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
					cellValue = dateFormat.format(dates);
				}
			}else {
				Double  doubles = cell.getNumericCellValue();
				if(doubles == doubles.intValue()){
					cellValue = doubles.intValue() + "";
				}else{
					cellValue = doubles +"";
				}
			}
			break;
		case Cell.CELL_TYPE_FORMULA:
			try {
				 cellValue = String.valueOf(cell.getNumericCellValue());    
			} catch (IllegalStateException e) {
			    cellValue = String.valueOf(cell.getRichStringCellValue());
			}
			break;
		case Cell.CELL_TYPE_BOOLEAN:
			cellValue = String.valueOf(cell.getBooleanCellValue());
			break;
		default:
			cellValue = cell.toString();
			break;
		}
		return cellValue;
	}