Aspose Excell export use Smart markers

[sunzq071]

I use .net aspose.cell to export excell. I want to export mutiple fields in one cell. The sample code is below.

Workbook workbook = new Workbook(fileName);
var head = new
{
InvoiceNo = "INV001",
SerialNo = "202503270001"
};

List headattr = new List();
headattr.Add(head);

var designer = new WorkbookDesigner();
designer.Workbook = workbook;
designer.SetDataSource("head", headattr);
designer.Process();
var guidPath = Path.Combine("D:\TestAspose\Files", $"{Guid.NewGuid().ToString("N")}.xlsx");
workbook.Save(guidPath);

I want to export head.InvoiceNo and head.SerialNo in Cell B3, I hope export the value like 'InvoiceNo:INV001;SetialNo:202503270001' in B3 .how should I write the smart markers in Cell B3?

[amjad-sahi]

@sunzq071,

If you need to add multiple values for different smart markers (fields) or concatenating markers values, you may simply add a new property/attribute to your data source for your custom needs. See the following sample code to accomplish your task for your reference.
e.g.,
Sample code:

var headList = new List<dynamic>();

headList.Add(new {
    InvoiceNo = "INV001",
    SerialNo = "202503270001",
    DisplayInfo = $"InvoiceNo:{"INV001"};SerialNo:{"202503270001"}"
});
Workbook workbook = new Workbook();
workbook.Worksheets[0].Cells["B3"].PutValue("&=head.DisplayInfo");
var designer = new WorkbookDesigner();
designer.Workbook = workbook;
designer.SetDataSource("head", headList);
designer.Process();
workbook.Save("e:\\test2\\out1.xlsx");

Hope, this helps a bit.

Note: As you are using a physical template Excel file, so you will insert smart marker, i.e, "&=head.DisplayInfo" into B3 cell of the first worksheet.