title: How to check whether the Excel sheet is complete in OpenXML
body: <p>We know that an Excel file is actually xml files. But one problem is that how the xml format hands blank cell is not well. </p>
  
  <p><a href="http://i.stack.imgur.com/KO1rU.jpg" rel="nofollow">enter image description here</a></p>
  
  <p>As you can see that in the second row, Column D is blank. So in the xml file, there is no corresponding node. But in the 9th row, there is Column D with its value.</p>
  
  <p>Because the code will read the cells one by one, and convert them into datatable. This results in dislocation of the column values. How should we resovle this? Is there anyway to complete the entire excel sheet? Even if it is a blank cell, we still add it to the xml file with some special value? Thanks!</p>