Dynamics for header and footer in Spreadsheets (Excel)

Updated March 16, 2023 15:03

As a part of Dynamics in Templafy is it now possible to make a dynamic header and footer in spreadsheets (Excel). It is possible to change this via the Templafy Designer. To use this feature will you need Dynamics version 1.7 and at least Templafy VSTO Add-in version 5.6.0.1664.

You can access this feature in Document via Templafy Template Designer

Multiple Header Footer Type can be attached to a single document. The Header Footer Type can be selected from a dropdown and these are the following types:

allHeader
firstHeader
evenHeader
oddHeader
allFooter
firstFooter
evenFooter
oddFooter

You can use expression bindings in the fields Left Section Value, Center Section Value and Right Section Value. Example of these bindings:

{{UserProfile.Title}}
{{Form.Date}}

When configuring in Template Designer consider that templates which already have header/footer for all pages you cannot configure headers/footers for odd and even pages (even though this is allowed in the UI of Template Designer). This limitation is valid also the other way around.

Note: Document Content Updater (DCU) is not supported in this version. This will require new VSTO release in the future.