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