Getting Notifications while Merging Data with Smart Markers

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

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

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
class SmartMarkerCallBack: ISmartMarkerCallBack
{
    Workbook workbook;

    public SmartMarkerCallBack(Workbook workbook) {
        this.workbook = workbook;
    }

    public void Process(int sheetIndex, int rowIndex, int colIndex, String tableName, String columnName) {
        Console.WriteLine("Processing Cell: " + workbook.Worksheets[sheetIndex].Name + "!" + CellsHelper.CellIndexToName(rowIndex, colIndex));
        Console.WriteLine("Processing Marker: " + tableName + "." + columnName);
    }
}

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

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); string outputPath = dataDir + "Output.out.xlsx"; // Creating a DataTable that will serve as data source for designer spreadsheet DataTable table = new DataTable("OppLineItems"); table.Columns.Add("PRODUCT_FAMILY"); table.Columns.Add("OPPORTUNITY_LINEITEM_PRODUCTNAME"); table.Rows.Add(new object[] { "MMM", "P1" }); table.Rows.Add(new object[] { "MMM", "P2" }); table.Rows.Add(new object[] { "DDD", "P1" }); table.Rows.Add(new object[] { "DDD", "P2" }); table.Rows.Add(new object[] { "AAA", "P1" }); // Loading the designer spreadsheet in an instance of Workbook Workbook workbook = new Workbook(dataDir + "source.xlsx"); // Loading the instance of Workbook in an instance of WorkbookDesigner WorkbookDesigner designer = new WorkbookDesigner(workbook); // Set the WorkbookDesigner.CallBack property to an instance of newly created class designer.CallBack = new SmartMarkerCallBack(workbook); // Set the data source designer.SetDataSource(table); // Process the Smart Markers in the designer spreadsheet designer.Process(false); // Save the result workbook.Save(outputPath);