You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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(IXLTableRowprimaryRowinprimaryTable.DataRange.Rows()){stringnum=primaryRow.Field("Num").GetValue<string>();// Use of filtering / LINQforeach(IXLTableRowjoinedRowinsecondaryTable.DataRange.Rows(row =>row.Field("PrimaryNum").GetValue<string>()==num)){stringfield=joinedRow.Field("MyField").GetValue<string>();// ...}}
The text was updated successfully, but these errors were encountered:
* #1821 - started work on a new DataRows api on ExcelTables
* Added GetFormula, Insert, Delete methods
* Fixed an xml comment
* #1821 - fixed some xml comments
---------
Co-authored-by: swmal <{ID}+username}@users.noreply.github.com>
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:
The text was updated successfully, but these errors were encountered: