title: How do I get an entire column in used range?
body: <p>I am trying to get a column, but limiting it to used range...</p>
  
  <pre><code>public static Excel.Application App = new Excel.Application();
  public static Excel.Workbook WB;
  
  WB = App.Workbooks.Open("xxx.xls", ReadOnly: true);
  
  var sheet = (WB.Sheets[1] as Excel.Worksheet);
  
  // returns 65536 rows, I want only 82 (used range)
  sheet.get_Range("F:F");
  
  sheet.UsedRange.get_Range("F:F").Rows.Count; // 65536
  </code></pre>
  
  <p>How can I get it?</p>