.
...
| Info |
|---|
ExcelWriter templates do not necessarily need to be in the Excel template file format (XLT, XLTX, XLTM), although these formats are supported by ExcelWriter. |
Datamarker syntax
The basic syntax for a datamarker is %%=DataSourceName.ColumnName, where DataSourceName is the name of the data source and ColumnName is the name of the column of data in the data source. You need to follow these rules when naming data markers:
...
Adding data markers to the the template
SOMETHING ABOUT ADDING DATA MARKERS TO THE TEMPLATE FILE
BLAH BLAH SCREEN SHOT
Formatting cells with data markers
BLAH BLAH BLAH NUMBER FORMAT
{{BLAH BLAH BLAH FONT FORMATTING ON CELLS }}
Writing the Code
SOMETHING ABOUT BINDROWDATA and BINDCOLUMN DATA
| Info |
|---|
If you want to import a row of data as a vertical column in Excel, you need to use ExcelTemplate.BindColumnData and the data marker syntax |
Final Code
| Csharp | ||||
|---|---|---|---|---|
| ||||
Add code here
|
| Vbnet | ||||
|---|---|---|---|---|
| ||||
Add code here |