Esempio n. 1
0
        public void Write(IEnumerable <Student> students, string fileName)
        {
            const string worksheetName    = "Sheet 1";
            const string averageGroupMark = "Average group mark:";

            using (ExcelPackage excelPackage = new ExcelPackage())
            {
                //Create the WorkSheet
                ExcelWorksheet        worksheet       = excelPackage.Workbook.Worksheets.Add(worksheetName);
                List <StudentToWrite> studentsToWrite = new List <StudentToWrite>();
                foreach (Student student in students)
                {
                    var studentToWrite = new StudentToWrite
                    {
                        Name        = student.Name,
                        Surname     = student.Surname,
                        Patronymic  = student.Patronymic,
                        AverageMark = student.GetAverageMark(),
                    };
                    studentsToWrite.Add(studentToWrite);
                }
                //Add some text to cell A1
                worksheet.Cells["A1"].LoadFromCollection(studentsToWrite);
                worksheet.Cells["F1"].Value = averageGroupMark;
                worksheet.Cells["F2"].Value = Student.GetAverageGroupMark(students);

                //Save your file
                FileInfo fi = new FileInfo(fileName);
                excelPackage.SaveAs(fi);
            }
        }
Esempio n. 2
0
 public void Write(IEnumerable <Student> students, string fileName)
 {
     using (StreamWriter writer = new StreamWriter(fileName, false, Encoding.UTF8))
     {
         List <StudentToWrite> collectionOfStudents = new List <StudentToWrite>();
         foreach (Student student in students)
         {
             var studentToWrite = new StudentToWrite
             {
                 Name        = student.Name,
                 Surname     = student.Surname,
                 Patronymic  = student.Patronymic,
                 AverageMark = student.GetAverageMark(),
             };
             collectionOfStudents.Add(studentToWrite);
         }
         writer.Write(JsonConvert.SerializeObject(collectionOfStudents));
     }
 }