Importing from Custom Objects

Developers can import data from a collection of objects to a worksheet using ImportCustomObjects. You can provide a list of columns/properties to the method to display your desired list of objects.

 //Instantiate a new Workbook
 Workbook book = new Workbook();

 //Clear all the worksheets
 book.Worksheets.Clear();

 //Add a new sheet "Data";
 Worksheet sheet = book.Worksheets.Add("Data");

 //Define List
 List<WeeklyItem> list = new List<WeeklyItem>();

 //Add data to the list of objects
 list.Add(new WeeklyItem() { AtYarnStage = 1, InWIPStage = 2, Payment = 3, Shipment = 4, Shipment2 = 5 });
 list.Add(new WeeklyItem() { AtYarnStage = 5, InWIPStage = 9, Payment = 7, Shipment = 2, Shipment2 = 5 });
 list.Add(new WeeklyItem() { AtYarnStage = 7, InWIPStage = 3, Payment = 3, Shipment = 8, Shipment2 = 3 });

 //We pick a few columns, not all, to import to the worksheet
 sheet.Cells.ImportCustomObjects((System.Collections.ICollection)list,
     new string[] { "Date", "InWIPStage", "Shipment", "Payment" },
     true,
     0,
     0,
     list.Count,
     true,
     "dd/mm/yyyy",
     false);

 //Auto-fit all the columns
 book.Worksheets[0].AutoFitColumns();

 //Save the Excel file
 book.Save("ImportedCustomObjects.xls");