/// <summary> /// Creates a real excel worksheet for the config if not already exists. /// </summary> public void CreateConfigSheet() { var configSheet = Worksheets.SingleOrDefault(sheet => sheet.Name == WorkbookConfig.DefaultSheetName); if (configSheet != null) { return; } var excelSheet = (MSExcel.Worksheet)myApplication.ActiveWorkbook.Worksheets.Add( Type.Missing, ((ExcelWorksheet)Worksheets.Last()).ExcelSheet, Type.Missing, Type.Missing); excelSheet.Name = WorkbookConfig.DefaultSheetName; }