How to handle empty cell using apache-poi

Question

How can I handle an empty cell using poi jars? This is the code:

public static String getdata(String SheetName, String ObjectLabel, int row) throws InvalidFormatException, IOException{
    String objvalue = null;
    FileInputStream fi = new FileInputStream(dir + "\\src\\pack\\TaurusRefactored\\TaurusRegistration1.xls");
    Workbook w = WorkbookFactory.create(fi);
    Sheet s = w.getSheet(SheetName);
    int rowcount = s.getLastRowNum();
    int columncount = s.getRow(0).getLastCellNum();
    for (int i = 0; i < columncount; i++) {
        String objlabl = s.getRow(0).getCell(i).getStringCellValue();
        if (objlabl.equals(ObjectLabel)) {
            switch (s.getRow(row).getCell(i).getCellType()) {
            case Cell.CELL_TYPE_STRING:
                objvalue = s.getRow(row).getCell(i).getStringCellValue().trim();
                break;
            case Cell.CELL_TYPE_NUMERIC:
                objvalue = Integer.toString((int) s.getRow(row).getCell(i).getNumericCellValue());
                break;
            case Cell.CELL_TYPE_BLANK:
                objvalue = "";
            default:
                break;
            }
        }
    }
     return objvalue;
}

I am getting the error the switch statement: (s.getRow(row).getCell(i).getCellType()) while taking the data from an empty cell.

possible duplicate of How to get an Excel Blank Cell Value in Apache POI? — Gagravarr
– Gagravarr, Commented Nov 21, 2014 at 22:25

Gagravarr · Accepted Answer · 2014-11-21 22:21:27Z

1

You just return cell null and blank value then read it.

Cell cell = row.getCell(cn, Row.RETURN_NULL_AND_BLANK);
if ((cell == null) || (cell.equals("")) || (cell.getCellType() == cell.CELL_TYPE_BLANK))

edited Nov 21, 2014 at 22:21

Gagravarr

48.5k11 gold badges114 silver badges158 bronze badges

answered Nov 21, 2014 at 12:16

RDY

6931 gold badge10 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to handle empty cell using apache-poi

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related