title: Removing empty rows in excel using C#
body: <p>I want to remove <strong>empty rows</strong> at the end of program exection. In details I am inserting some results after calculation using <strong>C#</strong> in predefined excel sheets. At the end I need to delete/remove the empty rows programatically. Could any one suggest solution. My code is little big so I am unable to include here. For your understanding I am giving some input and output view of excel. In below Output Excel the rows <strong>D</strong> and <strong>E</strong> having empty row I want to remove programatically without mentioning the range.</p>
  
  <p>Input Excel /Pre defined Excel Files</p>
  
  <pre><code>A   1   2   3   4
  B
  C
  D
  E
  </code></pre>
  
  <p>output Excel</p>
  
  <pre><code>A   1   2   3   4
  B   ABc cde nAC 123
  C   cdf fed x2  123
  D
  E
  </code></pre>