title: How can I get the Range of filtered rows using Excel Interop?
body: <p>I'm using Excel Interop assemblies for my project,
  if I want to use auto filter with then thats possible using </p>
  
  <pre><code>sheet.UsedRange.AutoFilter(1,SheetNames[1],Microsoft.Office.Interop.Excel.XlAutoFilterOperator.xlAnd,oMissing,false)
  </code></pre>
  
  <p>but how can I get the filtered rows ??</p>
  
  <p>can anyone have idea??</p>