A template marker is a special marker symbol created in an Excel template that will be bound to data.

Essential XlsIO allows you to create and bind markers with data from various sources, such as a data table, variables, and arrays. This will allow the user to control the format of the data when it is bound to a template document.

Marker Syntax

Each marker starts with a prefix, by default it is the "%" character; it is followed by the variable name and properties. There can be several arguments after the variable that are delimited by a character; by default, it is the ";" character.

Arguments

• horizontal or vertical - Specifies the direction of the data import for complex variables

• insert - Specifies the new row or column, depending on direction argument, for each new cell.

• insert:copystyles - Copies the style from the above row or left column

• jump:[cell reference in R1C1 notation] - Can be relative or absolute

• copyrange:[top-left cell reference in R1C1]:[bottom-right cell reference in R1C1] - Copies specified cells after each
cell import

Features:

This sample demonstrates the following template-marker usages:

• Marker arrays
• Marker with data table
• Marker with formula
• How rows are pushed down when data is bound to markers?
• How conditional formatting is applied using markers?

Interactive Features:

• Select the check box to open the generated document within the browser window.
• Click Create XLS to generate and view the document.
• All features in the preceding list are illustrated in this file.