public static void GenerateStudentBooklet(Parameters param)
{
var preReq = new PreRequisites();
for (int year = Util.MIN_YEAR; year < Util.MAX_YEAR; year++)
{
foreach (var subject in param.ReportController.GetSubjects(year))
{
var book = XLApp.OpenWorkbook(param.GetPath(Parameters.ReportType.SubjectOutline, year, subject.Item1));
Worksheet sheet = book.Sheets[Util.SUBJECT_ASSESSMENT_SHEET_NAME];
preReq.ParseSubjectAssessmentOutline(sheet);
book.Close(false);
}
}
preReq.WriteToSheet(param.ReportController.GetNewLeadsToSheet());
XLApp.Excel().Run("GenerateStudentTrackingBooklet");
}
