title: How to use Epplus with cells containing few rows
body: <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>