Alternative to deprecated getCellType

Question

I m reading an excel-file  file extension xlsx  using org apache poi 3 15    This is my code   try  FileInputStream fileInputStream   new FileInputStream file   XSSFWorkbook workbook   new XSSFWorkbook file         XSSFSheet sheet   workbook getSheetAt 0       Iterator lt Row gt  rowIterator   sheet iterator        while  rowIterator hasNext              Row row   rowIterator next             Iterator lt Cell gt  cellIterator   row cellIterator            while  cellIterator hasNext                  Cell cell   cellIterator next                switch  cell getCellType                      case Cell CELL TYPE NUMERIC                      System out print cell getNumericCellValue       Integer  t                        break                  case Cell CELL TYPE STRING                      System out print cell getStringCellValue       String  t                        break                                  System out println              catch  Exception e        e printStackTrace        I get a warning that cell getCellType   is deprecated  Can anyone tell me the alternative

User · Answer

You can use   cell getCellTypeEnum     Further to compare the cell type  you have to use CellType as follows -  if cell getCellTypeEnum      CellType STRING                               You can Refer to the documentation  Its pretty helpful -  https   poi apache org apidocs org apache poi ss usermodel Cell html

User · Answer

From the documentation      int getCellType     Deprecated  POI 3 15  Will return a CellType enum in the future       Return the cell type  Will return CellType in version 4 0 of POI  For forwards compatibility  do not hard-code cell type literals in your code

User · Answer

You can do this  private String cellToString HSSFCell cell        CellType type      Object result      type   cell getCellType         switch  type            case NUMERIC      numeric value in excel             result   cell getNumericCellValue                break          case STRING     String Value in Excel             result   cell getStringCellValue                break          default               throw new RuntimeException  quot There is no support for this type of value in Apche POI quot              return result toString

User · Answer

Use getCellType     switch  cell getCellType         case BOOLEAN                      To-do                  break     case NUMERIC                     To-do                  break     case STRING                     To-do                  break

User · Answer

For POI 3 17 this worked for me  switch  cellh getCellTypeEnum          case FORMULA           if  cellh getCellFormula   indexOf  LINEST    gt   0                value   Double toString cellh getNumericCellValue               else               value   XLS getDataFromCellValue evaluator evaluate cellh                      break      case NUMERIC          value   Double toString cellh getNumericCellValue             break      case STRING          value   cellh getStringCellValue            break      case BOOLEAN          if cellh getBooleanCellValue                 value    true             else               value    false                     break      default          value               break

User · Answer

The accepted answer shows the reason for the deprecation but misses to name the alternative    CellType    getCellTypeEnum     where the CellType is the enum decribing the type of the cell   The plan is to rename getCellTypeEnum   back to getCellType   in POI 4 0

User · Answer

FileInputStream fis   new FileInputStream new File  C  Test xlsx            create workbook instance     XSSFWorkbook wb   new XSSFWorkbook fis          create a sheet object to retrieve the sheet     XSSFSheet sheet   wb getSheetAt 0          to evaluate cell type     FormulaEvaluator formulaEvaluator   wb getCreationHelper   createFormulaEvaluator         for Row row   sheet                for Cell cell   row                        switch formulaEvaluator evaluateInCell cell  getCellTypeEnum                              case NUMERIC                  System out print cell getNumericCellValue       t                    break              case STRING                  System out print cell getStringCellValue       t                    break              default                  break                                   System out println            This code will work fine  Use getCellTypeEnum   and to compare use just NUMERIC or STRING

User · Answer

It looks that 3 15 offers no satisfying solution  either one uses the old style with Cell CELL TYPE    or we use the method getCellTypeEnum   which is marked as deprecated  A lot of disturbances for little add value

[java] Alternative to deprecated getCellType

Examples related to java

Examples related to apache-poi