EPPLUS shift down a row
<p>I'm working on a migration project from the  <strong>Microsoft.Office.Interop.Excel</strong> library To EPPlus in <strong>c#</strong> and what I want it's to get the the equivalent of this code using <strong>EEplus</strong> library.</p>

<p>I'm using a template XLSX file with 7 rows and depending rows data I want the insert a new row with the same style.</p>

<pre><code>if (MyData.Tables[0].Rows.Count&gt;3) 
            {
                for (int j=1;j&lt;MyData.Tables[0].Rows.Count-3;j++)
                {
                    for (int i1=1;i1&lt;29;i1++)
                    {
                        EXCEL.Range TheRange = (EXCEL.Range) ws.Cells[7,i1];
                        TheRange.Insert(EXCEL.XlInsertShiftDirection.xlShiftDown,missing);

                    }
                }
            }
</code></pre>

<p><a href="https://drive.google.com/file/d/0B4atrkOwAJq5c3lKRTVuZWxrck0/view?usp=sharing" rel="nofollow noreferrer">view xlsx template</a>
and the result with
<a href="https://drive.google.com/file/d/0B4atrkOwAJq5dV90dVdKZDdqbnc/view?usp=sharing" rel="nofollow noreferrer">Epplus without shiftdown</a></p>