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(); }