/**
* 获取单元格数据
*/
protected static String getCellValue(Cell cell) {
String cellValue = "";
if (cell != null) {
switch (cell.getCellType()) {
case Cell.CELL_TYPE_STRING:
cellValue = cell.getStringCellValue();
break;
case Cell.CELL_TYPE_NUMERIC:
String dataFormat = cell.getCellStyle().getDataFormatString();
if (DateUtil.isCellDateFormatted(cell)) {
cellValue = sdf.format(cell.getDateCellValue());
} else if ("@".equals(dataFormat)) {
cellValue = df.format(cell.getNumericCellValue());
} else {
cellValue = String.valueOf(cell.getNumericCellValue());
DecimalFormat df = new DecimalFormat("#.#########");
cellValue=df.format(Double.valueOf(cellValue));
}
break;
case Cell.CELL_TYPE_BOOLEAN:
cellValue = String.valueOf(cell.getBooleanCellValue());
break;
case Cell.CELL_TYPE_FORMULA:
cellValue = cell.getCellFormula();
break;
default:
cellValue = "";
}
}
return cellValue;
}