POI 中的CellType类型以及值的对应关系

迈不过友情╰ 2022-04-16 03:48 779阅读 0赞

<table style="width:500px;"> 
 <thead> 
  <tr> 
   <th>CellType&nbsp;&nbsp; &nbsp;</th> 
   <th>类型&nbsp;&nbsp; &nbsp;</th> 
   <th>值</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>CELL_TYPE_NUMERIC&nbsp;&nbsp; &nbsp;</td> 
   <td>数值</td> 
   <td>0</td> 
  </tr> 
  <tr> 
   <td>CELL_TYPE_STRING&nbsp;&nbsp; &nbsp;</td> 
   <td>字符串型</td> 
   <td>1</td> 
  </tr> 
  <tr> 
   <td>CELL_TYPE_FORMULA&nbsp;&nbsp; &nbsp;</td> 
   <td>公式型</td> 
   <td>2</td> 
  </tr> 
  <tr> 
   <td>CELL_TYPE_BLANK&nbsp;&nbsp; &nbsp;</td> 
   <td>空值</td> 
   <td>3</td> 
  </tr> 
  <tr> 
   <td>CELL_TYPE_BOOLEAN&nbsp;&nbsp; &nbsp;</td> 
   <td>布尔型</td> 
   <td>4</td> 
  </tr> 
  <tr> 
   <td>CELL_TYPE_ERROR&nbsp;&nbsp; &nbsp;</td> 
   <td>错误</td> 
   <td>5</td> 
  </tr> 
 </tbody> 
</table>

在解析excel的时候，通常值考虑前四种情况

若想获取单元格的值，推荐以下方式：

public String getCellValue(Cell cell) {
        String temp = "";
        if (cell == null) {
          return temp;
        }
        switch (cell.getCellType()) {
          case Cell.CELL_TYPE_STRING:
            return cell.getRichStringCellValue().getString();
          case Cell.CELL_TYPE_NUMERIC:
            if (DateUtil.isCellDateFormatted(cell)) {
              Date date = cell.getDateCellValue();
              DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
              temp = df.format(date);
            } else {
              return String.valueOf(cell.getNumericCellValue());
            }
          case Cell.CELL_TYPE_FORMULA:
            cell.setCellType(Cell.CELL_TYPE_STRING);
            return cell.getStringCellValue();
    
          default:
            return temp;
        }
      }