How do i clear rows in Excel using EPPLus library ?

Nepethya Rana

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.

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nepethya Rana9y ago
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 .
0
Sundaram Subramanian9y ago
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.
0
alice yang9y ago
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.
0