Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Comment iterate through rows dans an excel table using epplus?

ayi

I am new to <a href="https://epplus.codeplex.com/" rel="noopener nofollow ugc">epplus</a>, and i’m trying to read some values from an excel table.
This is what I have so far:
<pre><code class="lang-auto">var fileInfo = new FileInfo(filename);
using(var excelPackage = new OfficeOpenXml.ExcelPackage(fileInfo))
{
foreach (var sheet in excelPackage.Workbook.Worksheets)
{
foreach (ExcelTable table in sheet.Tables)
{
foreach(var row in table.Rows) // <-- !!
{ ... }
}
}
}

</code></pre>
However, now I am stumped, as the <code>ExcelTable</code> only has a <code>Columns</code> property, but not a <code>Rows</code> property as I had expected. I cannot find a <code>Rows</code> property on any object in the library.
How do I iterate through a table, reading Row for Row?
<hr>
Source : <a href="https://epplus.codeplex.com/" rel="noopener nofollow ugc">Stack Overflow</a>,)

ayi_2

While searching for help on the same problem, I stumbled across this <a href="http://codealoc.wordpress.com/2012/04/19/reading-an-excel-xlsx-file-from-c/">link</a>. It certainly worked for me! Definitely better than using Interop objects. <img src="https://forum-microsoft.fr/images/emoji/twitter/slight_smile.png?v=15" title=":slight_smile:" class="emoji" alt=":slight_smile:" loading="lazy" width="20" height="20">
I adapted it slightly though:
<pre><code class="lang-auto">var package = new ExcelPackage(new FileInfo("sample.xlsx"));

ExcelWorksheet workSheet = package.Workbook.Worksheets[0];
var start = workSheet.Dimension.Start;
var end = workSheet.Dimension.End;
for (int row = start.Row; row <= end.Row; row++)
{ // Row by row...
for (int col = start.Column; col <= end.Column; col++)
{ // ... Cell by cell...
object cellValue = workSheet.Cells[row, col].Text; // This got me the actual value I needed.
}
}

</code></pre>