Have utility methods to iterate over Excel tables

[Sebazzz]

Is your feature request related to a problem? Please describe.
While EPPlus is great for creating Excel files, it is not as convenient to use for consuming Excel packages.

What I like from ClosedXML is that they offer useful abstractions for iterating over Excel tables, distinguishing columns, rows, and cells.

Unless I'm missing something, EPPlus does not have anything like this.

Describe the solution you'd like

Example from ClosedXML:

foreach (IXLTableRow primaryRow in primaryTable.DataRange.Rows()) {
    string num = primaryRow.Field("Num").GetValue<string>();

    // Use of filtering / LINQ
    foreach (IXLTableRow joinedRow in secondaryTable.DataRange.Rows(row => row.Field("PrimaryNum").GetValue<string>() == num)) {
            string field = joinedRow .Field("MyField").GetValue<string>();

           // ...
    }
}

[AdrianEPPlus]

We are not entirely sure what you are asking for. Could you describe you issue in more detail?

[Sebazzz]

Being able to iterate over Excel table rows and address cells by column name.

[swmal]

@Sebazzz This makes sense. We'll consider adding something similar to your suggestion.