title: Adding a specific autofilter on a column
body: <p>I'm trying to set a filter on a column. This is the way I did it in Interop:</p>
  
  <pre><code>private void CheckMasterFile(string path) {
      var xlApp = new Excel.Application();
      var xlWorkbook = xlApp.Workbooks.Open(path);
      Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
  
      foreach (var project in projects) {
          if (string.IsNullOrEmpty(project.ProjectID.Value)) {
              continue;
          }
  
          var xlRange = xlWorksheet.UsedRange;
          if (xlWorksheet.AutoFilter != null) {
              xlWorksheet.AutoFilterMode = false;
          }
          xlRange.AutoFilter(Field: 2, Criteria1: project.ProjectID.Value);
          var result = xlRange.SpecialCells(Excel.XlCellType.xlCellTypeVisible, Type.Missing);//only shows filtered values
          double sum = 0;
  
          foreach (Excel.Range row in result.Rows) {
              if (row.Cells[2, 2].Value2() != null) {
                  if (!NOT_ALLOWED_RUBRIQUES.Contains((string)row.Cells[2, 8].Value2())) {//check if rubrique is allowed or not
                      //finish method
                  }
              }
          }
      }
      xlWorkbook.Close(SaveChanges: false);
      xlApp.Quit();
  }
  </code></pre>
  
  <p>But the only way I can do something with autofilter in EPPlus is to enable or disable it, not to filter a column on a specific value.
  Something like this:</p>
  
  <pre><code>sheet.Cells["A RANGE HERE"].AutoFilter = true;
  </code></pre>
  
  <p>So what I'm trying to achieve here is to filter a huge Excel file on a specific value and then only show the rows with those values.</p>