Exemplos de WannaApp.Excel.Helpers.MappingHelpers.TransferHelper.TransferFromExcelFormat em C# (CSharp)

Exemplo n.º 1

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