title: reading Excel Open XML is ignoring blank cells
body: <p>I am using the <a href="https://stackoverflow.com/questions/3321082/from-excel-to-datatable-in-c-with-open-xml">accepted solution here</a> to convert an excel sheet into a datatable.  This works fine if I have "perfect" data but if I have a blank cell in the middle of my data it seems to put the wrong data in each column.</p>
  
  <p>I think this is because in the below code:</p>
  
  <pre><code>row.Descendants&lt;Cell&gt;().Count()
  </code></pre>
  
  <p>is number of populated cells (not all columns) AND:</p>
  
  <pre><code>GetCellValue(spreadSheetDocument, row.Descendants&lt;Cell&gt;().ElementAt(i));
  </code></pre>
  
  <p>seems to find the next populated cell (not necessarily what is in that index)  so if the first column is empty and i call ElementAt(0), it returns the value in the second column.</p>
  
  <p>Here is the full parsing code.</p>
  
  <pre><code>DataRow tempRow = dt.NewRow();
  
  for (int i = 0; i &lt; row.Descendants&lt;Cell&gt;().Count(); i++)
  {
      tempRow[i] = GetCellValue(spreadSheetDocument, row.Descendants&lt;Cell&gt;().ElementAt(i));
      if (tempRow[i].ToString().IndexOf("Latency issues in") &gt; -1)
      {
          Console.Write(tempRow[i].ToString());
      }
  }
  </code></pre>