/// <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;
}
