C# EPPlus delete row from excel sheet
<p>I'm currently working with an Excel file that has leading rows that have information I don't need.  These extra rows also mess with importing that data in the header row below.  So I'm trying to remove them to work with the data. </p>

<pre><code>using (var pack = new ExcelPackage(myFileInfo))
{
    // Should return the sheet name
    var ws = pack.Workbook.Worksheets.FirstOrDefault();
    // Should Delete rows 1-5 and shift up the rows after deletion
    ws.DeleteRow(1,5,true);
}
</code></pre>

<p>I was thinking something like the above would work, but I've not had much success with it.  </p>

<p>The goal would be to delete rows 1-5, shift up the rest of the data (maybe a merge would work?) then convert it into a datatable.  </p>

<p>Anyone have tips tips or resources on removing rows from my excel sheet (prior to moving it into a datatable since that is where the issue occurs)</p>