foreach (Worksheet wsheet in entire_workbook.Worksheets) if (wsheet.Name.Equals(sheet_name)) { Excel.DisplayAlerts = false; wsheet.Delete(); entire_workbook.Save(); Excel.DisplayAlerts = true; break; } weekly_worksheet = (Worksheet)weekly_workbook.Sheets[1]; //entire_worksheet = (Worksheet)entire_workbook.Worksheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value); weekly_worksheet.Copy(entire_worksheet, Missing.Value); //error occurs here entire_workbook.Save(); weekly_workbook.Save(); entire_workbook.Close(false, Type.Missing, Type.Missing);
try { Worksheet wsh = YourWorkbook.Worksheets["WorksheetName"]; wsh.Delete(); } catch (...) { //do not inform about errors ;) } //now you can add worksheet with the same name ;)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)