/**
* 获取单元格各类型值,返回字符串类型
*
* @param cell
* @return
*/
private String getCellValue(Cell cell) {
String cellValue = null;
CellType cellType = cell.getCellType();
switch (cellType) {
case STRING:
cellValue = cell.getStringCellValue();
break;
case NUMERIC:
cellValue = cell.getNumericCellValue() + "";
if (HSSFDateUtil.isCellDateFormatted(cell)) {
Date date = cell.getDateCellValue();
if (date != null) {
cellValue = new SimpleDateFormat("yyyy/MM/dd").format(date);
} else {
cellValue = "";
}
}
else {
HSSFDataFormatter hssfDataFormatter = new HSSFDataFormatter();
cellValue = hssfDataFormatter.formatCellValue(cell);
}
break;
case FORMULA:
cellValue = cell.getCellFormula() + "";
break;
case BLANK:
cellValue = "";
break;
case ERROR:
cellValue = "非法字符";
}
return cellValue;
}