public void MappingManagerTest()
{
var manager = new WannaApp.Excel.Helpers.MappingHelpers.TransferHelper <TestObjecten.NewTestObject>().SetDynamicColumnsFor("DynamicStrings", new List <string> {
"frans", "Geert"
});
Assert.AreNotEqual(null, manager.HeaderValues);
}
public void HeaderMappinginfoTest()
{
var helper = new ExcelToObjectMappingHelper();
var transferHelper = new WannaApp.Excel.Helpers.MappingHelpers.TransferHelper <TestObjecten.NewTestObject>()
.SetDynamicColumnsFor("DynamicStrings", new List <string> {
"frans", "Geert"
});
var result = helper.Process(new string[] { "Eerste Sleutel", "Tweede sleutel", "Tekst", "Getal", "Datum", "Decimaal", "frans", "Geert", "DynamicInts" }, transferHelper.MappingInfoToExcel);
Assert.AreNotEqual(null, result);
Assert.AreNotEqual(0, result.Count);
}
public void WorkBookWorkSheetCreateListObjectFromObjects()
{
RemoveFile();
var excel = StartExcel();
var test = new ExcelApplication(excel);
var workbook = test.AddNewWorkbook();
var helper = new WannaApp.Excel.Helpers.MappingHelpers.TransferHelper <TestObjecten.NewTestObject>()
.SetDynamicColumnsFor("DynamicStrings", new List <string> {
"frans", "Geert"
})
.TransferToExcelFormat(GetTestDataNewTestObjects());
var list = workbook.FindOrCreateWorksheet("frans").CreateListObject("A1", helper, "eerste");
var retrievedList = workbook.GetListObjectByName("eerste");
var retrieveddata = helper.TransferFromExcelFormat(retrievedList).GetObjectsFromExcel();
workbook.SaveAsWorkbook(_filename);
excel.Quit();
Assert.AreNotEqual(null, list);
}
public void WorkBookWorkSheetContainesListObject()
{
var excel = StartExcel();
var test = new ExcelApplication(excel);
var workbook = test.AddNewWorkbook();
var helper = new WannaApp.Excel.Helpers.MappingHelpers.TransferHelper <TestObjecten.NewTestObject>()
.SetDynamicColumnsFor("DynamicStrings", new List <string> {
"frans", "Geert"
})
.TransferToExcelFormat(GetTestDataNewTestObjects());
var worksheet = workbook.FindOrCreateWorksheet("frans");
var list = worksheet.CreateListObject("A1", helper, "ListObjectName");
var found = worksheet.ContainsListObjectByName("ListObjectName");
var notFound = worksheet.ContainsListObjectByName("noExistingListName");
var workbookFound = workbook.GetListObjectByName("ListObjectName");
var workbookNotFound = workbook.GetListObjectByName("noExistingListName");
Assert.AreEqual(true, found);
Assert.AreEqual(false, notFound);
Assert.AreNotEqual(null, workbookFound);
Assert.AreEqual(null, workbookNotFound);
workbook.Close(false);
excel.Quit();
}
