Basic steps to create a Template Report:

1.	First, you have to tell FlexCel in what cells you want to replace the values. To replace values in a given sheet, always define a  __XXXX__ name there. If you don't define anything, FlexCel won't do anything either, allowing it to skip processing in sheets where you don't want to. Note: There are 2 “_” in the name. Is “__X__”, not “_X_”

2.	After that you have to tell FlexCel what cells you want to change. To do this, write either ##DatasetName##FieldName or #.Property in those cells. The ## is for replacing values from a database, while the #. is for replacing with published properties.

Also, a special case is shown. Excel doesn't have a Date datatype, so, FlexCel sends all Dates as Numbers. You have to format all cells that will contain dates as Date, if not, you will see numbers. 

Note: From V2.1, always that you can use published properties, you can also use the “Values” property. That is, instead of defining a “Current_Date” prop, you could have written “Report.Values[‘CurrentDate’]:=now; You can also use Array of variants this way.