title: How to read Excel cell having null values too in Java...?
body: <p>I'm using Apache POI 3.6. I've a column which is <strong>blank</strong>. I would like to be able to read it and then move to the next column. Even if I could resolve the  <code>NullPointerException</code> problem I could not get to the next cell.</p>
  
  <p>Here's my code snippet :</p>
  
  <pre><code>HSSFCell cell = row.getCell(c);
  String value = null;
  
  switch (cell.getCellType()) {
  
      case HSSFCell.CELL_TYPE_FORMULA:
          value = "FORMULA value=" + cell.getCellFormula();
          break;
  
      case HSSFCell.CELL_TYPE_NUMERIC:
          value = "NUMERIC value=" + cell.getNumericCellValue();
          break;
  
      case HSSFCell.CELL_TYPE_STRING:
          value = "STRING value=" + cell.getStringCellValue();
          break;
  
      case HSSFCell.CELL_TYPE_BLANK:
          value="";
          break;
  
      case HSSFCell.CELL_TYPE_ERROR:
          value="error";
          break;
  
      default:
          break;
  }
  
  System.out.println("CELL col=" + cell.getColumnIndex() + " VALUE=" + value);
  </code></pre>
  
  <p>How can I resolve my problem?</p>