Unable to delete a worksheet using EPPlus

Question

I am using this code:

ExcelPackage pck = new ExcelPackage(newFile);

var wk = pck.Workbook.Worksheets.SingleOrDefault(x => x.Name == "Content");

pck.Workbook.Worksheets.Delete(wk);

But in delete it gives me "IndexOutOfRangeException", but I am trying to delete from object, I have tried to delete by index "1", I just have two worksheets, and the same exception. The file and worksheet is not null, but when I execute delete in anyway I receive the "IndexOutOfRangeException".

What's happening?

Note: I have created this worksheet from ExcelPackage too and now i want delete it.

I'm having the same exception with this one-liner: while (wb.Worksheets.Count > 0) wb.Worksheets.Delete(0);. — Uwe Keim
BTW, when changing my code to while (wb.Worksheets.Count > 0) wb.Worksheets.Delete(1);, no exception occurs. Seems that the index is one-based, not zero-based. — Uwe Keim
You haven't added any worksheets called "Content" so why wouldn't wk be null? — Chris

Deilan Deilan · Accepted Answer · 2014-12-23T04:03:24

Looks like you ran into some temporary bug/issue, that was already fixed. As of EpPlus 4.0.1.1, the following code works just fine:

var workbookFileInfo = new FileInfo(@"Workbook.xlsx");
using (var excelPackage = new ExcelPackage(workbookFileInfo))
{
    excelPackage.Workbook.Worksheets.Add("Worksheet1");
    excelPackage.Workbook.Worksheets.Add("Worksheet2");
    excelPackage.Save();
}
using (var excelPackage = new ExcelPackage(workbookFileInfo))
{
    var worksheet = excelPackage.Workbook.Worksheets.SingleOrDefault(x => x.Name == "Worksheet1");
    excelPackage.Workbook.Worksheets.Delete(worksheet);
    excelPackage.Save();
}

Try to update to the latest available stable version of EpPlus and if will not help you, please post additional details applicable for the latest version.

Unable to delete a worksheet using EPPlus

1 Answers