private IWorksheet GetOrCreateConfigSheet() { var configSheet = Worksheets.SingleOrDefault(sheet => sheet.Name == WorkbookConfig.DefaultSheetName); if (configSheet == null) { // we will NOT create a new excel sheet here - we do not // know whether we are inside a maui workbook. configSheet = new InMemoryWorksheet(this, WorkbookConfig.DefaultSheetName); } return(configSheet); }
private IWorksheet GetOrCreateConfigSheet() { var configSheet = Worksheets.SingleOrDefault(sheet => sheet.Name == WorkbookConfig.DefaultSheetName); if (configSheet == null) { var file = Path.Combine(myDirectory, WorkbookConfig.DefaultSheetName + ".csv"); File.Create(file); configSheet = new CsvWorksheet(this, file, mySeparator); } return(configSheet); }
/// <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; }