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.

}

Sundar · Answer

You can try like this ExcelPackage package = new ExcelPackage(); ExcelWorksheet ws = package.Workbook.Worksheets[ Sheet2 ]; ws.Cells[ A24:C36 ].Clear(); To Clear a Particular Cells.

Nepethya Rana · Answer

ws.DeleteRow(2 ws.Dimension.End.Row); this method worked. I would learn Free Spire.XLS as well. Thank you for recommendation. Thank you for reaching out and helping me out .

alice yang · Answer

Hi Just another alternative solution: //Load Excel file Workbook workbook = new Workbook(); workbook.LoadFromFile( test.xlsx ); //Get the first worksheet Worksheet sheet = workbook.Worksheets[0]; //Clear contents of the first row sheet.Rows[0].ClearContents(); //Clear content as well as format of the second row sheet.Rows[1].ClearAll(); //Save the file workbook.SaveToFile( result.xlsx  ExcelVersion.Version2013); You can get the dll of Free Spire.XLS via nuget and use the above code. Hope it's helpful.