public String getStringCellValue(HSSFCell cell) {
String strCell = "";
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_STRING:
strCell = cell.getStringCellValue().trim();
break;
case HSSFCell.CELL_TYPE_NUMERIC:
java.text.NumberFormat nf = NumberFormat.getCurrencyInstance();
DecimalFormat df = (DecimalFormat) nf;
df.setDecimalSeparatorAlwaysShown(true);
df.applyPattern("###############");
String value = df.format(new Double(cell.getNumericCellValue()));
strCell = String.valueOf(value);
break;
case HSSFCell.CELL_TYPE_BOOLEAN:
strCell = String.valueOf(cell.getBooleanCellValue());
break;
case HSSFCell.CELL_TYPE_BLANK:
strCell = "";
break;
default:
strCell = "";
break;
}
if (strCell.equals("") || strCell == null) {
return "";
}
if (cell == null) {
return "";
}
return strCell;
}
获取Excel单元格数据内容为字符串类型的数据
最新推荐文章于 2023-12-27 18:42:56 发布