Set custom DataSource for WorkbookDesigner

Contents
[ ]

Aspose.Cells provides the option to set custom DataSource for WorkbookDesigner. The API provides an overloaded method WorkbookDesigner.SetDataSource which takes the name of the source as the first parameter and the instance of the class that implements ICellsDataTable as the second parameter. 

The following code snippet demonstrates the use of WorkbookDesigner.SetDataSource method to set the custom DataSource.

Sample Code

The implementation of CustomerDataSource, Customer, and CustomerList classes is given below

The source and output excel files are attached for reference.

Source File

Output File

Auto Populate Smart Marker Data to Other Worksheets if Data is too Large Show leading apostrophe in cells