title: find the last used row in a column in windows c#
body: <p>I have a excel report and i need to draw charts based on the data in the report. Am able to get the range from a particular column to last filled row like shown below. I have many columns in my report and i need only the data in a particular column like ("c1","
  c12"). the column length may vary. it need not be 12. How can i get the range till last filled row of a column. </p>
  
  <pre><code>Excel.Range last1 = xlWorkSheet2.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell, Type.Missing);
  oRange = xlWorkSheet2.get_Range("A6", last1);
  </code></pre>