title: C# - Excel - How to delete visible rows after AutoFilter?
body: <p>I´m working on a little commandline tool to extract some data from an excel sheet.</p>
  
  <p>I want to delete all rows which are visible after applying an AutoFilter.</p>
  
  <p>Unfortunately, I just don´t know how to continue.
  After some searching, I did not find a working answer for me.</p>
  
  <p>Here is what I´ve got so far:</p>
  
  <pre><code>        oXL = new Excel.Application();
          oXL.Visible = false;
          oWB = oXL.Workbooks.Open(source);
          oXS = (Excel.Worksheet)oWB.Sheets[1];
  
          Excel.Range filter = oXS.UsedRange;
          filter.AutoFilter(8, "&lt;&gt;text to filter");
  </code></pre>
  
  <p>How do I delete all rows which are shown after filtering?</p>
  
  <p>Thanks.</p>
  
  <p>CRowland</p>