HSSFCell 读单元格的数据类型

来源:互联网 发布:澳洲商婚 知乎 编辑:程序博客网 时间:2024/06/05 22:35
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 = "";          }  
原创粉丝点击