Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Smartly Importing Variable Arrays into Excel With Smart Markers
Contents
[
Hide
]
Why Use 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
The following example code shows how to use variable arrays in Smart Markers. We place a variable‑array marker into cell A1 of the first worksheet of the workbook dynamically, which contains a string of values that we set for the marker, process the markers to fill data into the cells corresponding to the marker, and finally save the Excel file.
How to Import an HTML Property with Smart Markers
The following sample code demonstrates the use of the HTML property of Smart Markers. When processed, it will display “World” in “Hello World” as bold because of the HTML <b> tag.