public void AppendeUserExcelFile() { IWriter <User> write = new ExcelWriter <User>("Users", new StringList { "Name", "Firstname" }); write.Write(new User("Tata", "Roro"), ExcelFile); write.Append <UserList>(new User("Tata", "Roro"), ExcelFile); IGenericReader <User> reader = new ExcelReader <User>("Users", new StringList { "Name", "Firstname" }); UserList usersToCompare = reader.read <UserList>(ExcelFile); Assert.IsNotNull(usersToCompare); Assert.AreEqual("Roro", usersToCompare[0].Firstname); Assert.AreEqual("Tata", usersToCompare[0].Name); Assert.AreEqual("Roro", usersToCompare[1].Firstname); Assert.AreEqual("Tata", usersToCompare[1].Name); }
public void AppendListExcelFile() { ListSerializable <User> users = new UserList(); users.Add(new User("Toto", "Titi")); users.Add(new User("Tata", "Roro")); IWriter <User> write = new ExcelWriter <User>("Users", new StringList { "Name", "Firstname" }); write.Write <UserList>(users, ExcelFile); write.Append <UserList>(users, ExcelFile); IReader <User> reader = new ExcelReader <User>("Users", new StringList { "Name", "Firstname" }); ListSerializable <User> usersToCompare = reader.read <UserList>(ExcelFile); Assert.IsNotNull(usersToCompare); Assert.AreEqual(users[0].Firstname, usersToCompare[0].Firstname); Assert.AreEqual(users[0].Name, usersToCompare[0].Name); Assert.AreEqual(users[1].Firstname, usersToCompare[1].Firstname); Assert.AreEqual(users[1].Name, usersToCompare[1].Name); Assert.AreEqual(users[0].Firstname, usersToCompare[2].Firstname); Assert.AreEqual(users[0].Name, usersToCompare[2].Name); Assert.AreEqual(users[1].Firstname, usersToCompare[3].Firstname); Assert.AreEqual(users[1].Name, usersToCompare[3].Name); }