Smartly Importing Variable Arrays into Excel With Smart Markers
Contents
[
Hide
]
Why Using Variable Arrays for Smart Markers
Variable arrays (e.g., «products[0].name» or «foreach item in cart») enable dynamic handling of repeated data structures in templates. They solve limitations of flat/nested objects when dealing with lists, tables, or collections.
- Dynamic Repetition Without Hardcoding: Static markers fail for variable-length data (e.g., order items, user permissions). Arrays iterate dynamically.
- Simplified Aggregation: Calculate sums, averages, or filters directly. Avoid manual JavaScript/C# logic in templates.
- Tabular/List Data Representation: Natural fit: Tables, grids, and lists inherently map to arrays.
- Memory Efficiency: Arrays reduce template complexity and data-binding overhead.
- Integration with APIs/Data Sources: Aligns with JSON/array-centric data (e.g., REST APIs).
How to Import Variable Arrays With Smart Markers
Following example code shows on how to use variable arrays in Smart Markers. We place a variable array marker into A1 cell of the first worksheet of the workbook dynamically which contains string of values which we set for the marker, process the markers to fill data into the cells against the marker. Finally we save the Excel file.
How to Import HTML Property With Smart Markers
The following sample code explains the use of HTML property of the Smart Markers. When it will be processed, it will show “World” in “Hello World” as bold because of HTML tag.