public static String getValueAsString(XSSFCell cell){
String value;
switch (cell.getCellType()) {
case XSSFCell.CELL_TYPE_STRING:
value = cell.getStringCellValue();
break;
case XSSFCell.CELL_TYPE_NUMERIC:
DecimalFormat df = new DecimalFormat("###############.##########");// 格式化 number String 字符
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");// 格式化日期字符串
if(DateUtil.isCellDateFormatted(cell))
value = sdf.format(HSSFDateUtil.getJavaDate(cell.getNumericCellValue()));
else
value=df.format(cell.getNumericCellValue()).trim();
//value = cell.getRawValue();
break;
case XSSFCell.CELL_TYPE_BOOLEAN:
value = String.valueOf(cell.getBooleanCellValue());
break;
case XSSFCell.CELL_TYPE_BLANK:
value = "";
break;
case XSSFCell.CELL_TYPE_ERROR:
value = "";
break;
case XSSFCell.CELL_TYPE_FORMULA:
// value=cell.getRawValue();
value=String.valueOf(cell.getNumericCellValue());
break;
default:
value = cell.toString();
}
return value;
}
String value;
switch (cell.getCellType()) {
case XSSFCell.CELL_TYPE_STRING:
value = cell.getStringCellValue();
break;
case XSSFCell.CELL_TYPE_NUMERIC:
DecimalFormat df = new DecimalFormat("###############.##########");// 格式化 number String 字符
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");// 格式化日期字符串
if(DateUtil.isCellDateFormatted(cell))
value = sdf.format(HSSFDateUtil.getJavaDate(cell.getNumericCellValue()));
else
value=df.format(cell.getNumericCellValue()).trim();
//value = cell.getRawValue();
break;
case XSSFCell.CELL_TYPE_BOOLEAN:
value = String.valueOf(cell.getBooleanCellValue());
break;
case XSSFCell.CELL_TYPE_BLANK:
value = "";
break;
case XSSFCell.CELL_TYPE_ERROR:
value = "";
break;
case XSSFCell.CELL_TYPE_FORMULA:
// value=cell.getRawValue();
value=String.valueOf(cell.getNumericCellValue());
break;
default:
value = cell.toString();
}
return value;
}