Getting Notifications while Merging Data with Smart Markers

Aspose.Cells APIs provide the WorkbookDesigner class to work with Smart Markers, where the formatting and formulas are placed in the designer spreadsheets and then processed with the WorkbookDesigner class to populate the data according to the specified Smart Markers. Sometimes, it may be required to receive notifications about the cell reference or the particular Smart Marker being processed. This can be achieved using the WorkbookDesigner.CallBack property and the ISmartMarkerCallBack interface introduced in Aspose.Cells for .NET 8.6.2.

The following piece of code demonstrates the usage of the ISmartMarkerCallBack interface to define a new class that handles the callback for the WorkbookDesigner.Process method.

The rest of the process includes loading the designer spreadsheet containing the Smart Markers with WorkbookDesigner and processing it by setting the data source. In order to keep the example simple, we used a predefined designer spreadsheet containing only two Smart Markers, as shown in the snapshot below, where the data source is created dynamically to merge the data according to the specified Smart Markers.