CELL_TYPE_STRING cannot be resovled or is not a field

淩亂°似流年 2023-02-15 15:54 29阅读 0赞

![20200606133851810.png][]

参考链接：[https://stackoverflow.com/questions/52514468/cell-type-string-cannot-be-resolved-or-is-not-a-field][https_stackoverflow.com_questions_52514468_cell-type-string-cannot-be-resolved-or-is-not-a-field]

参考链接：[https://blog.csdn.net/weixin\_43209201/article/details/86519522][https_blog.csdn.net_weixin_43209201_article_details_86519522]

Java操作Excel之POI: HSSFCell.CELL\_TYPE\_STRING、HSSFCell.CELL\_TYPE\_BOOLEAN和HSSFCell.CELL\_TYPE\_NUMERIC无定义

# 解决办法 #

导入CellType包import org.apache.poi.ss.usermodel.CellType;  
使用CellType.STRING代替HSSFCell.CELL\_TYPE\_STRING  
同理，HSSFCell.CELL\_TYPE\_BOOLEAN、HSSFCell.CELL\_TYPE\_NUMERIC等无定义的解决办法与上面类似。

switch (cell.getCellType()) {
          case NUMERIC:{
               cellValue = String.valueOf(cell.getNumericCellValue());
               break;
          }
          
          case STRING:{
               cellValue = cell.getStringCellValue();
               break;
          }
          case BOOLEAN:{
               break;
          }
          case FORMULA:{
               break;
          }
     
          default:
               break;
    }

[20200606133851810.png]: https://img-blog.csdnimg.cn/20200606133851810.png
[https_stackoverflow.com_questions_52514468_cell-type-string-cannot-be-resolved-or-is-not-a-field]: https://stackoverflow.com/questions/52514468/cell-type-string-cannot-be-resolved-or-is-not-a-field
[https_blog.csdn.net_weixin_43209201_article_details_86519522]: https://blog.csdn.net/weixin_43209201/article/details/86519522