.
...
| Note |
|---|
This example assumes an understanding of ExcelTemplate. If you are not familiar with how to set up an Excel template with data markers, please go through the Simple Expense Summary first. |
Using
...
Ordinal Syntax
Here is the starting template: 
The next few steps will show the process of using ordinal syntax and data marker modifiers.
ExcelTemplate normally requires the data marker for a column of data to specify the data set and the column name (e.g. %%=DataSource.ColumnName). In the event that the column name or data source name is unknown, ExcelWriter supports the use of ordinal numbering based on the data source column.
...
However, in this example, we will only change the column name, as shown below:
Using Data Marker Modifiers
In addition to ordinal syntax, ExcelWriter supports data marker modifiers, which are tags that change how and what data is imported into the file.
This template uses two different data marker modifiers - fieldname and optional. Modifiers are added in parentheses at the end of a data marker. They alter the binding behavior of the data marker.
The fieldname modifier shows the fieldname field name of the column being bound. The syntax is as follows:
...