public Object getCellValue(HSSFCell cell) {
Object value = "";
if (cell != null) {
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_FORMULA:
break;
case HSSFCell.CELL_TYPE_NUMERIC:
cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
DecimalFormat format = new DecimalFormat("#");
value =format.format(cell.getNumericCellValue());
break;
case HSSFCell.CELL_TYPE_STRING:
value = cell.getStringCellValue().trim();
break;
default:
value = null;
break;
}
}
return value;
}
判断*.xls文件单元格数据类型方法封装
最新推荐文章于 2024-03-18 07:32:55 发布