private void CreateFromTemplate(string templateFilePath)
{
Application excel = new Application();
_workbook = excel.Workbooks.Open(templateFilePath);
var worksheets = _workbook.Worksheets;
foreach (var ws in worksheets)
{
Worksheet worksheet = (Worksheet)ws;
if (worksheet.Name == "Facilities")
{
_facilitiesWorksheet = new FacilitiesWorkSheet(worksheet);
}
else if (worksheet.Name == "Devices")
{
_devicesWorksheet = new DevicesWorksheet(worksheet);
}
else if (worksheet.Name == "Facilities schedule")
{
_facilitiesScheduleWorksheet = new FacilitiesScheduleWorksheet(worksheet);
}
Debug.WriteLine($"{worksheet.Name}");
}
}
private void CreateFromScratch()
{
_Application excel = new _Excel.Application();
_workbook = excel.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
// create worksheets
var worksheet = _workbook.Worksheets[1];
_facilitiesWorksheet = new FacilitiesWorkSheet(worksheet);
_facilitiesWorksheet.Init();
worksheet = excel.Worksheets.Add(After: worksheet);
_facilitiesScheduleWorksheet = new FacilitiesScheduleWorksheet(worksheet);
_facilitiesScheduleWorksheet.Init();
worksheet = excel.Worksheets.Add(After: worksheet);
_devicesWorksheet = new DevicesWorksheet(worksheet);
_devicesWorksheet.Init();
}