title: C# EPPlus delete row from excel sheet
body: <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>