Retrieve the grouped rows of an excel sheet programmatically using Excel-VBA & C#

Retrieve the grouped rows of an excel sheet programmatically using
Excel-VBA & C#

I want to retrieve the filtered rows (filtered using EmailAddress) of an
excel sheet programmatically, using C# with the reference of EPPlus
Library. Then I can able to write those grouped records into separate
excel files.
Note: Mine is C# console application. Library using for Excel operations:
EPPlus.dll
Anybody has ideas, please pop it out. Thanks.