title: Filter Condition With EPPlus
body: <p>I have found that you can use this syntax to filter a workbook with EPPlus <code>range.AutoFilter = true;</code></p>
  
  <p>But I have not seen if/how I can pass in a filter parameter.    For example, using the Excel Interop - I would use</p>
  
  <pre><code>range.AutoFilter(1, range.Cells[2, 1].Value);
  </code></pre>
  
  <p>Does EPPlus have the equivalent of such?</p>
  
  <p><strong>EDIT</strong><br>
  What I am after here is the ability to copy all rows (including headers) from a master worksheet to sub-worksheets.  </p>
  
  <p>For example, if the master worksheet looks like this</p>
  
  <pre><code>Name   A   B   C   D
  Joe    XX  XX  XX  XX
  Joe    XX  XX  XX  XX
  Joe    XX  XX  XX  XX
  Jack   AA  AA  AA  AA
  Jack   AA  AA  AA  AA
  Jim    BB  BB  BB  BB
  </code></pre>
  
  <p>The steps I would need to occur are</p>
  
  <blockquote>
    <p>1) Create a new worksheet, name it Joe
    <br>2) Copy all data for Joe (including headers to new worksheet)
    <br>3) Repeat process for all names in the list</p>
  </blockquote>
  
  <p><strong>I have this working with Excel Interop, but of course using this course is SLOW!</strong></p>