How do i clear rows in Excel using EPPLus library ?

Question

How do i clear rows in Excel using EPPLus library ?

Right now I am providing hard code value as I know the number of rows in excel that has data in it.

I would like my program knows how to clear the excel and import new data everytime in excel sheet.

How do i acheieve this ?

 

My code :

 

 

using (ExcelPackage xlPackage = new ExcelPackage(new System.IO.FileInfo(sourcefile + fileName)))
{
ExcelWorksheet ws = xlPackage.Workbook.Worksheets[myWS];
ws.DeleteRow(2, 300);

 

// Other codes to import data. 

}