...
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.
...
%%=Products.ProductID | The "ProductID" column of the data source "Products." |
---|---|
%%=#2.FirstName | The "FirstName" column of the second data source defined in the ExcelWriter code. |
%%=Employee.#3 | The third column of the "Employee" data source. |
%%=#2.#3 | 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
Anchor | ||||
---|---|---|---|---|
|
...
Note |
---|
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. |
...