poi导入excel判断单元格类型及转换

private String getCellValue(HSSFCell cell) {String cellValue = "";DecimalFormat df = new DecimalFormat("#");switch (cell.getCellType()) {case HSSFCell.CELL_TYPE_STRING:cellValue = cell.getRichStringCellValue().getString().trim();break;case HSSFCell.CELL_TYPE_NUMERIC:cellValue = df.format(cell.getNumericCellValue()).toString();break;case HSSFCell.CELL_TYPE_BOOLEAN:cellValue = String.valueOf(cell.getBooleanCellValue()).trim();break;case HSSFCell.CELL_TYPE_FORMULA:cellValue = cell.getCellFormula();break;default:cellValue = "";}return cellValue;}