public ExcelSheet(string fileName, string sheetName) : base(fileName)
{
Data = new SheetData(this);
Formatting = new SheetFormatting(this);
DataProcessor = new SheetDataProcessor(this);
if (SheetExists(sheetName))
{
Worksheet = Worksheets[sheetName];
return;
}
else if (SheetExists(sheetName.ToUpper()))
{
Worksheet = Worksheets[sheetName.ToUpper()];
return;
}
else if (SheetExists(sheetName.ToLower()))
{
Worksheet = Worksheets[sheetName.ToLower()];
return;
}
Worksheet = Worksheets.Add();
Worksheet.Name = sheetName;
}
public void Init(SheetDataProcessor sdp)
{
_sdp = sdp;
ViewModel = new ComboViewVM
{
AllComboNames = _sdp.MostUsedCombos.Select(x => x.Name).ToArray(),
AllExercises = _sdp.AllExercises.Select(x => x.Name).ToArray(),
};
itemsControl.DataContext = ViewModel;
}
