Using Nested Objects
Contents
[
Hide
]
Aspose.Cells supports nested objects in smart markers, the nested objects should be simple.Individual class need to be defined by user for below code.
We use a simple template file. See the designer spreadsheet that contains some nested smart markers.
string FilePath = @"..\..\..\Sample Files\";
string FileName = FilePath + "Using Nested Object.xlsx";
//Initialize WorkbookDesigner object
WorkbookDesigner designer = new WorkbookDesigner();
//Load the template file
designer.Workbook = new Workbook(FileName);
//Instantiate the List based on the class
System.Collections.Generic.ICollection<Individual> list = new System.Collections.Generic.List<Individual>();
//Create an object for the Individual class
Individual p1 = new Individual("Damian", 30);
//Create the relevant Wife class for the Individual
p1.Wife = new Wife("Dalya", 28);
//Create another object for the Individual class
Individual p2 = new Individual("Mack", 31);
//Create the relevant Wife class for the Individual
p2.Wife = new Wife("Maaria", 29);
//Add the objects to the list
list.Add(p1);
list.Add(p2);
//Specify the DataSource
designer.SetDataSource("Individual", list);
//Process the markers
designer.Process(false);
//Save the Excel file.
designer.Workbook.Save(FileName);