CELL_TYPE_NUMERIC cannot be resolved or is not a field

Question

Guys any help I can get here I will appreciate it. I keep getting this error message not sure what's going on. "both Cell type numeric and string cannot be resolved"

          while (cellIterator.hasNext()){
                  final Cell cell = cellIterator.next();
                    switch (cellIndex)
                    {
                        case 0:
                            if(cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
                                newStudent.studentId = (int)cell.getNumericCellValue();
                                cellIndex++;
                            }
                            break;
                            
                        case 1:
                            if(cell.getCellType() == Cell.CELL_TYPE_STRING) {
                                newStudent.major = cell.getStringCellValue();
                                cellIndex++;
                            }else {
                                newStudent.major = null;
                            }
                            break;
                            
                        case 2:
                            if(cell.getCellType() == Cell.CELL_TYPE_STRING) {
                                newStudent.gender = cell.getStringCellValue();
                                cellIndex++;
                            }else {
                                newStudent.gender = null;
                            }
                            break;
                    }
                    
                }

score 2 · Answer 1 · answered Jul 27 '20 at 01:04

2

Instead of

Cell.CELL_TYPE_STRING
Cell.CELL_TYPE_NUMERIC

Use these:

CellType.STRING
CellType.NUMERIC

Reference link is CellType

answered Jul 27 '20 at 01:04

Wils Mils

613
4
9

wow that's actually it... Thanks – papa Jul 27 '20 at 01:13
@papa, please do not forget to choose your accepted answer. click buttons of appreciation. – Wils Mils Jul 27 '20 at 18:56

score 1 · Answer 2 · answered Jul 27 '20 at 01:02

1

I'm not actually familiar with Apache POI, but from the documentation here, it looks like you might need to get CellType.NUMERIC instead of Cell.CELL_TYPE_NUMERIC, and CellType.STRING instead of Cell.CELL_TYPE_STRING?

answered Jul 27 '20 at 01:02

tensixes

121
1
1
4

CELL_TYPE_NUMERIC cannot be resolved or is not a field

2 Answers2