title: How to get an Excel Blank Cell As NULL
body: <p>I have to get value from excel using Apache POI. I have two cases</p>
  
  <ol>
  <li>Have to get Exact value from Excel cell</li>
  <li>The NULL value should be return while get the Value</li>
  </ol>
  
  <p>For first case i have using <code>new DataFormatter().formatCellValue(row.getCell(index))</code> this method exactly return the value from Excel.  But if the cell has Empty value then it didn't return value as NULL.</p>
  
  <p>I also tried with <code>new DataFormatter().formatCellValue(row.getCell(index, HSSFRow.RETURN_BLANK_AS_NULL))</code></p>
  
  <p>Please refer the attached screen shot!  <a href="http://i.stack.imgur.com/vkjlT.jpg" rel="nofollow">Here we have to get the Description value as null
  Excel with null values</a></p>