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