A data marker binds in script to a data source which may be a variable, an array, or an ADO.NET DataSet, DataTable, or DataReader. A data marker may include modifiers. Data source and field numbers are 1-based. If ExcelWriter encounters %%=#0[.field] or %%=[DataSource.]#0, an error will occur.
The "ProductID" column of the data source "Products."
The "FirstName" column of the second data source defined in the ExcelWriter code.
The third column of the "Employee" data source.
The third column of the second data source defined in the ExcelWriter code.
- Data Marker Names
- Data Marker Formats
- Short Data Markers
- Long Data Markers
- Grouping and Nesting Markers
- Data Marker Modifiers
Data Marker Names
In ExcelWriter 4, a $ was required for all data markers that bind to 1-dimensional arrays. In ExcelWriter 5 and above, if a 1-dimensional array binds to a row of data markers by the ExcelTemplate.SetRowDataSource or ExcelTemplate.BindRowData methods, the $ should be omitted. However, for backward compatibility, if you include the $, the data marker will be populated without error.