Demonstrates the various options and switches that can be used with data markers in ExcelTemplate template workbooks.

Technical Overview

ExcelTemplate data markers always begin with %%= and are then followed by data source name and field information (see the guide).  They can also have optional modifiers that change the behavior or the data marker when the report is generated. 

Here are some of the data marker options that are shown in this demo:

(optional)

Silently removes the data marker if it is not bound by any data source

(preserve)

Forces number strings to be treated as text

(fieldname)

Displays the field name of the data column to which it is bound, instead of the data itself

(uppercase)

Displays all text in uppercase

(lowercase)

Displays all text in lowercase

View the template to see where the various marker options are written. Then, run the demo to observe their behaviors and appearances in the generated workbook.

Click to run demo

Copyright 2005 © SoftArtisans, Inc. All Rights Reserved.