How to use Epplus with cells containing few rows
<p>I want to import some excel file using epplus
the problem is that some cells contains more than one row (and that cause a problem</p>

<p>My excel look like this (in realite their is more tests (test2,test3....)</p>

<p><a href="https://i.stack.imgur.com/addiw.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/addiw.jpg" alt="enter image description here"></a></p>

<p>I can only get the first column by this algorithm..but it will be more complicated to get the seconde column</p>

<pre><code> //this is the list than contain applications (column 2)
ICollection&lt;Application&gt; applications = new  List&lt;Application&gt;();
            int i = 0;

            for (int j = workSheet.Dimension.Start.Row;
                    j &lt;= workSheet.Dimension.End.Row;
                    j=i+1)
            {
                 //this is the object that contain the first column
                //and also a list of the second column  (foreach domain thei `is a list of applications (column 2)`          
                Domaine domaine = new Domaine();

                i += 1;

                //add here and  not last row
                while (workSheet.Cells[i, 1].Text == "" &amp;&amp; i &lt; workSheet.Dimension.End.Row)
                {

                    i++;
                }

                if (i &gt; workSheet.Dimension.End.Row)
                    break;
                domaine.NomDomaine = workSheet.Cells[i, 1].Text;
                domaines.Add(domaine);

            }
</code></pre>

<p>Edit : in other words  is their a way to get the number of rows in one cell , OR a way to duplicate  the value of each row in the cell</p>

<p>(for exemple if i have a cell from row 1 to 14  and the row number 5 have value)
how can i duplicate that text to all the rows (that will help me solving the problem)</p>