请参考 private String getStringCellValue(HSSFCell cell) { String value = null; if (cell == null) return null; switch (cell.getCellType()) { case HSSFCell.CELL_TYPE_BOOLEAN: value = String.valueOf(cell.getBooleanCellValue()); break; case HSSFCell.CELL_TYPE_NUMERIC: value = new java.text.SimpleDateFormat("yyyy-MM-dd").format(cell.getDateCellValue()); break; case HSSFCell.CELL_TYPE_ERROR: value = String.valueOf(cell.getErrorCellValue()); break; case HSSFCell.CELL_TYPE_FORMULA: case HSSFCell.CELL_TYPE_BLANK: case HSSFCell.CELL_TYPE_STRING: value = cell.getStringCellValue(); break; } return value.trim(); }
private String getStringCellValue(HSSFCell cell) { String value = null;
if (cell == null)
return null;
switch (cell.getCellType()) { case HSSFCell.CELL_TYPE_BOOLEAN:
value = String.valueOf(cell.getBooleanCellValue());
break;
case HSSFCell.CELL_TYPE_NUMERIC:
value = new java.text.SimpleDateFormat("yyyy-MM-dd").format(cell.getDateCellValue());
break;
case HSSFCell.CELL_TYPE_ERROR:
value = String.valueOf(cell.getErrorCellValue());
break;
case HSSFCell.CELL_TYPE_FORMULA:
case HSSFCell.CELL_TYPE_BLANK:
case HSSFCell.CELL_TYPE_STRING:
value = cell.getStringCellValue();
break;
}
return value.trim();
}
HSSFCell cell= firstRow.createCell((short)0);
//单元格类型为文本
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
//单元格类型为数字(货币)
cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);