函数学习 有些事,记下来是不错的选择...

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;
                        }
                }