public void AddWorkSheetsTest()
{
ExcelManager manager = new ExcelManager();
manager.AddWorkSheets(new StringList {
"Worksheet1", "Worksheet2"
}, ExcelFile);
try
{
//try to go on new worksheets
manager.ChangeCellValue(ExcelFile, "Worksheet1", "A1", "Test");
manager.ChangeCellValue(ExcelFile, "Worksheet2", "A1", "Test");
}
catch
{
Assert.Fail();
}
}
public void ChangeCellExcel()
{
ExcelWriter <User> writer = new ExcelWriter <User>("Users", new StringList {
"Name", "Firstname"
});
writer.Write(new User("test", "test"), ExcelFile);
ExcelManager manager = new ExcelManager();
manager.ChangeCellValue(ExcelFile, "Users", "A2", "LALA");
manager.ChangeCellValue(ExcelFile, "Users", "B2", "LALA");
IReader <User> reader = new ExcelReader <User>("Users", new StringList {
"Name", "Firstname"
});
Collection <User> usersList = reader.read <UserList>(ExcelFile);
Assert.AreEqual(1, usersList.Count);
Assert.AreEqual("LALA", usersList[0].Name);
Assert.AreEqual("LALA", usersList[0].Firstname);
}