Java HSSFCell.CELL_TYPE_ 更新为CellType.

错误原因:jar包版本更新,官方改动;

解决方法:

  • 导入CellType包:import org.apache.poi.ss.usermodel.CellType
  • 使用CellType.STRING代替HSSFCell.CELL_TYPE_STRING
if(cell==null||cell. Equals(null)||cell.getCellType()==CellType.BLANK){value="null";}else {//判断数据类型switch (cell.getCellType()) {case FORMULA:value = "" + cell.getCellFormula();break;case NUMERIC:value = "" + cell.getNumericCellValue();break;case STRING:value = cell.getStringCellValue();break;default:break;}}
if(cell==null||cell.equals("")||cell.getCellType()==HSSFCell.CELL_TYPE_BLANK){value="null";}else {//判断数据类型switch (cell.getCellType()) {case HSSFCell.CELL_TYPE_FORMULA:value = "" + cell.getCellFormula();break;case HSSFCell.CELL_TYPE_NUMERIC:value = "" + cell.getNumericCellValue();break;case HSSFCell.CELL_TYPE_STRING:value = cell.getStringCellValue();break;default:break;}}

留下评论