private static Workbook GenerateExcel(SubjectRegister subjectRegister) { Workbook workbook = new Workbook(); workbook.LoadFromFile("Files/Template.xlsx", ExcelVersion.Version2010); Worksheet worksheet = workbook.Worksheets[0]; var students = subjectRegister.GetStudentList(); worksheet.SetCellValue(4, 3, subjectRegister.Code + " " + subjectRegister.Id + " " + subjectRegister.Subject); worksheet.SetCellValue(5, 3, subjectRegister.Professor); worksheet.SetCellValue(6, 3, subjectRegister.StartDateString()); worksheet.SetCellValue(7, 3, subjectRegister.EndDateString()); int count = 9; bool first = false; foreach (var student in students) { if (first) { worksheet.InsertRow(count); worksheet.Copy(worksheet.Range["A" + (count - 1).ToString() + ":J" + (count - 1).ToString()], worksheet.Range["A" + count.ToString() + ":J" + count.ToString()], true); } worksheet.SetCellValue(count, 1, student.Id.ToString()); worksheet.SetCellValue(count, 3, student.Career); worksheet.SetCellValue(count, 4, student.FullName); first = true; count++; } worksheet.SetCellValue(count, 3, students.Count.ToString()); return(workbook); }
public void AddSubjectRegister(SubjectList aSubjectList) { if (aSubjectList.getCount() == 0) { Console.WriteLine("\n ************************************************************************"); Console.WriteLine("\t Para utilizar esta opcion debe agregar asignaturas."); Console.WriteLine("\n ************************************************************************"); } else { var newSubjectRegister = new SubjectRegister(); Console.WriteLine("\n Agregar registro de asignatura \n"); Console.WriteLine("\t Asignaturas disponibles para creacion de registro de asignatura: \n"); aSubjectList.ListSubjects(); Console.Write("\n \n Escriba el ID de la asignatura con que desea crear nuevo registro de asignatura: "); int id = Convert.ToInt32("0" + Console.ReadLine()); if (aSubjectList.GetIdList().Contains(id)) { newSubjectRegister.SetSubject(aSubjectList.SearchAndReturn(id)); newSubjectRegister.SetAtributes(lastId + 1); lastId++; this.subjectRegisters.Add(newSubjectRegister); } else { Console.WriteLine("Id invalido."); } } }
public static void ExportPdf(SubjectRegister subjectRegister) { var workbook = GenerateExcel(subjectRegister); workbook.SaveToFile("Files/Registro.pdf", Spire.Xls.FileFormat.PDF); }
public static void ExportExcel(SubjectRegister subjectRegister) { var workbook = GenerateExcel(subjectRegister); workbook.SaveToFile("Files/Registro.xlsx", ExcelVersion.Version2010); }