title: Apache Poi adding missing cell policy in XssfReader and SheetContentsHandler
body: <p>Consider the following Excel table</p>
  
  <pre><code>Id         Reference Id    Name
  20059136                    Gj
  20012323                    Am
  </code></pre>
  
  <p>How to handle missing cells in <code>Event model</code>  <code>XSSFReader</code>, While reading data here the column <code>Reference Id</code> is skipped and one left shift happens, hence all the values from <code>Name</code> column are appended over to <code>Reference Id</code> in the read output.</p>
  
  <p>How to find missing cells or empty/blank cells using <code>Apache POI</code> 'XssfReader' and 'SheetContentsHandler'.</p>
  
  <ol>
  <li>How to find the <code>missing cells</code> dynamically in case of a very large set of file reads? </li>
  <li>As well as how to add <code>MissingCellPolicy</code> in the case of `Event Model'?</li>
  </ol>
  
  <p>references</p>
  
  <ol>
  <li><a href="https://stackoverflow.com/a/36776914/4522875">https://stackoverflow.com/a/36776914/4522875</a></li>
  <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java" rel="nofollow noreferrer">https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java</a></li>
  </ol>
  
  <p>thanks.</p>