public void SetUpPathwayFile(int startYear, int endYear)
{
try
{
PathwayWorkbook = App.Workbooks.Add();
var worksheet = PathwayWorkbook.Worksheets.Add();
(worksheet as Worksheet).Name = campus;
(worksheet as Worksheet).Cells[2, 1] = "Students";
var yearCount = startYear;
var colCount = 2;
while (yearCount <= endYear)
{
(worksheet as Worksheet).Cells[1, colCount] = yearCount;
(worksheet as Worksheet).Cells[1, colCount + 1] = yearCount;
(worksheet as Worksheet).Cells[2, colCount] = 1;
(worksheet as Worksheet).Cells[2, colCount + 1] = 2;
yearCount += 1;
colCount += 2;
}
PathwayWorkbook.SaveAs(pathwayFilePath);
}
catch
{
Console.WriteLine("Failed setting up Pathway File.");
App.Quit();
throw;
}
}
public void SavePathwayFile()
{
try
{
PathwayWorkbook.Save();
}
catch
{
Console.WriteLine("Failed to Save Pathway File.");
App.Quit();
throw;
}
}
