public static void PhoneBook() { var persons = new List<Person> { new Person {Name = "A1", Family = "B", Phone = "C"}, new Person {Name = "A2", Family = "B", Phone = "C"}, new Person {Name = "A3", Family = "B", Phone = "C"}, new Person {Name = "A4", Family = "B", Phone = "C"}, new Person {Name = "A5", Family = "B", Phone = "C"} }; var excel = new OpenXmlWrapper(); var document = excel.Document("demo.xlsx"); excel.AddSheet(document.WorkbookPart, "Phone Book"); var sheet = document.WorkbookPart.WorksheetParts.First().Worksheet; excel.AddRow(sheet, true, "Name", "Family", "Phone"); foreach (var person in persons) { excel.AddRow(sheet, false, person.Name, person.Family, person.Phone); } //sheet.Save(); document.Close(); System.Diagnostics.Process.Start("demo.xlsx"); }
public static void Animals() { var animals = new List<Animal> { new Animal {Name = "Kitty", Type = "Cat", Age = 2}, new Animal {Name = "Robert", Type = "Dog", Age = 7}, new Animal {Name = "Chippopo", Type = "Monkey", Age = 2}, }; var excel = new OpenXmlWrapper(); var document = excel.Document("Animals.xlsx"); var sheet = excel.AddSheet(document.WorkbookPart, "My Animals"); excel.AddRow(sheet, true, "Animal name", "Animal Type", "Age"); foreach (var animal in animals) { excel.AddRow(sheet, false, animal.Name, animal.Type, animal.Age); } document.Close(); System.Diagnostics.Process.Start("Animals.xlsx"); }