.Net Excel Interop Deleting a worksheet

Question

I'm trying to delete a worksheet from a excel document from a .Net c# 3.5 application with the interop Excel class (for excel 2003).

I try many things like :

Worksheet worksheet = (Worksheet)workbook.Worksheets[1];
worksheet.Delete();

It's doesn't work and doesn't throw any error ...

Answer 1

I found why after more that one hour looking for the answer

app.DisplayAlerts = false;
worksheet.Delete();
app.Displayalerts = true;

where app is your XlsApplication

Answer 2

It is also important to note that the workbook must contain at least one worksheet; this means you cannot delete all worksheets in a workbook.