title: Obtaining Blank column values included in final output array from SpreadsheetExcelReader
body: <p>I am using the below plugin for reading micrsoft excel file (.xls extension)</p>
  
  <p><a href="http://php-spreadsheetreader.googlecode.com/svn-history/r26/Excel/OLERead.php" rel="nofollow">http://php-spreadsheetreader.googlecode.com/svn-history/r26/Excel/OLERead.php</a></p>
  
  <p>As per the current plugin implementation it returns the read excel as an array.</p>
  
  <p>The below code reads the excels and returns it as an array</p>
  
  <pre><code>        include_once('spreadsheet_excel_reader.php');
          $data = new Spreadsheet_Excel_Reader_New();
          $data-&gt;setOutputEncoding('CP1251');
          $data-&gt;read('full path of file');
          echo '&lt;pre&gt;';print_r($data-&gt;sheets[0]['cells']);echo '&lt;/pre&gt;';exit;
  </code></pre>
  
  <p>The array cells contains the number of values equal to number of rows in an excel sheet.</p>
  
  <p>Each of the value itself is an array consisting of number of keys equal to number of columns in the sheet.</p>
  
  <p>The array cells looks as below - </p>
  
  <pre><code>    [cells] =&gt; Array( 
                                [1] =&gt; Array
                                      (
                                          [1] =&gt; a
                                          [2] =&gt; b
                                          [3] =&gt; c
                                          [4] =&gt; d
                                          [5] =&gt; e
                                          [6] =&gt; f
                                          [7] =&gt; g
                                      )
  
                                  [2] =&gt; Array
                                      (
                                          [1] =&gt; fddfg
                                          [2] =&gt; dfgd
                                          [5] =&gt; ghjgh 
                                          [6] =&gt; dgdf
                                          [7] =&gt; uyijkgh
                                      )
  
                                  [3] =&gt; Array
                                      (
                                          [1] =&gt; fghfg
                                          [2] =&gt; gvsfdgdf
                                          [4] =&gt; fdg4t4  
                                          [5] =&gt; gfdg
                                          [6] =&gt; dfgd
                                          [7] =&gt; ghfghf
                                      )
  
                                  [4] =&gt; Array
                                      (
                                          [1] =&gt; fgh
                                          [2] =&gt; sfsdf
                                          [5] =&gt; fghfgh
                                          [6] =&gt; fsdf
                                          [7] =&gt; dfgdfg
                                      ) 
  )
  </code></pre>
  
  <p>As seen from the above array the key 1 contains array of headings of the sheet.
  So in all there are 7 columns in an excel sheet.
  Currently if any of the cell contains no value in sheet then it skips those values in an array
  but my requirement is that if a cell contains no values in that case the array should be containing blank values.</p>
  
  <p>In plugin this whole array creation process takes place in below function</p>
  
  <blockquote>
    <p>function _parsesheet($spos)</p>
  </blockquote>
  
  <p>I tries adding a new case for handling null entries but with no success.</p>
  
  <p>Any help on the above issue would be great.</p>