关于Microsoft.Office.Interop.Excel中删除sheet的注意事项

关于Microsoft.Office.Interop.Excel中删除sheet的注意事项

 Excel.Application app = new Microsoft.Office.Interop.Excel.Application();

Excel.Workbook wBook = app.Workbooks.Add(true);

Excel.Worksheet sheet = (Excel.Worksheet)wBook.Sheets.get_Item(wBook.Sheets.Count);
Excel.Worksheet wSheet = wBook.Worksheets.Add(After: sheet);

//敲黑板，划重点

app.DisplayAlerts = false;
(wBook.Worksheets[1]).Delete();
app.DisplayAlerts = true;
 wBook.Save();//删除后记得保存，否则将删除不了

 wBook.Close(false, Missing.Value, Missing.Value);//关闭
wBook = null;
app.Quit();
pp = null;GC.Collect();//强行销毁