java导入excel格式化单元格数据

/**
	 * 格式化cell数据
	 * 
	 * @param cell
	 * @return
	 */
	private String getCellVal(Cell cell, int cellNum) {
		Object obj = null;
		FormulaEvaluator evaluator = book.getCreationHelper().createFormulaEvaluator();
		CellValue cellValue = evaluator.evaluate(cell);
		if (cell.toString().length() > 0) {
			switch (cellValue.getCellType()) {
			case Cell.CELL_TYPE_BOOLEAN:
				obj = cellValue.getBooleanValue();
				break;
			case Cell.CELL_TYPE_NUMERIC:
				if (HSSFDateUtil.isCellDateFormatted(cell)) {
					Date date = cell.getDateCellValue();
					DateFormat formater = new SimpleDateFormat("yyyy-MM-dd");
					obj = formater.format(date);
				} else {
					if (cellNum <= 5) {
						obj = cell.toString().substring(0, cell.toString().indexOf("."));
					} else {
						if (cellValue.getNumberValue() < 1 && cellValue.getNumberValue() > 0) {
							obj = 0 + df.format(cellValue.getNumberValue());
						} else if (cellValue.getNumberValue() <= 0) {
							obj = "";
						} else {
							obj = df.format(cellValue.getNumberValue());
						}

					}
				}
				break;
			case Cell.CELL_TYPE_STRING:
				obj = cellValue.getStringValue();
				break;
			case Cell.CELL_TYPE_BLANK:
				break;
			case Cell.CELL_TYPE_ERROR:
				break;
			case Cell.CELL_TYPE_FORMULA:
				break;
			}
		} else {
			obj = "";
		}
		return obj.toString();
	}