Aspose.Cells Repeat Section in Excel for Each Record from Data Source

We have an example template which need to be populated with data from a JSON data source. We have clients for which a section in Excel need to be repeated for each client record. Here is the expected vs actual outcome when using smart markers. Please help us with how to achieve the expected outcome.

Expectation:
image.png (31.8 KB)

Actual Outcome:
image.png (10.3 KB)

@venkat.p,

Thanks for the screenshots.

Please note, Aspose.Cells’ Smart Markers feature has its own rules and specifications, so you cannot use it in your own custom way. There is no reliable way except doing manual copy/paste range(s) or insert data into the cells for your needs.

@Amjad_Sahi So there is no way we can repeat a section based on number of records using Aspose Cells?

@venkat.p,

Yes, there is no such option available to repeat certain records in Smart Markers. You have to insert repeated data into cells manually using Aspose.Cells APIs.