EPPlus 5 supports creating and applying filters, either as an autofilter on the worksheet or as a filter in a table. EPPlus supports the following filters:

- Value filters
- Date group filters
- Custom filters
- Top 10 filters
- Dynamic filters

## Example

Here is an example of how to add filters to a range ('p' in the code below is an instance of the ExcelPackage class).

```csharp
var ws = p.Workbook.Worksheets.Add("ValueFilter");
ExcelRangeBase range = await LoadFromDatabase(connectionString, ws);

range.AutoFilter = true;
var colCompany = ws.AutoFilter.Columns.AddValueFilterColumn(0);
colCompany.Filters.Add("Walsh LLC");
colCompany.Filters.Add("Harber-Goldner");
// ApplyFilter() will set the rows that don't match the filters to hidden.
ws.AutoFilter.ApplyFilter();
```

```vbnet
Dim ws = p.Workbook.Worksheets.Add("ValueFilter")
Dim range As ExcelRangeBase = Await LoadFromDatabase(connectionString, ws)

range.AutoFilter = True
Dim colCompany = ws.AutoFilter.Columns.AddValueFilterColumn(0)
colCompany.Filters.Add("Walsh LLC")
colCompany.Filters.Add("Harber-Goldner")
' ApplyFilter() will set the rows that don't match the filters to hidden.
ws.AutoFilter.ApplyFilter()
```

## See also

See [Sample 4.2-C\#](<https://github.com/EPPlusSoftware/EPPlus.Samples.CSharp/tree/master/04-Filters and validations/02-Filter>) or [Sample 4.2-VB](<https://github.com/EPPlusSoftware/EPPlus.Samples.VB/blob/master/04-Filters and validations/02-Filter>)