Getting started

  • Introduction
  • Create a new process
  • Configure template
  • Configure output settings
  • Add deliveries
  • Start process
  • Processes examples
  • Training videos

Integrations

  • Power Automate
  • Power Apps
  • Airtable
  • Zapier
  • Make
  • REST API
  • 2000+ integrations

Templates syntax

  • Word DOCX templates (Modern)
  • Word DOCX templates (Classic)
  • Excel XLSX templates
    • How it works
    • Tokens
    • Tables
    • Links
    • Loops and nesting
    • Formulas
    • Charts
    • Conditionally hide content
    • Automatic numbering
    • Merge cells vertically
    • Multiple worksheets
    • Aliases
    • Operations
    • Value formatters
    • Value properties
    • Update file metadata
    • Demos
  • PowerPoint PPTX templates
  • Fillable PDF
  • HTML templates

Forms

  • Auto-generated forms
  • Rich custom forms

General

  • Licensing details
  • Release notes
  • Architecture
  • Data protection and security
  • Data center location
  • Service level agreement
  • Status page

Account management

  • API Keys
  • Reports
  • Recycle bin
  • Subscriptions
  • Account settings
  • Audit log
  • Manage team

PDF processing and more

  • Convert DOCX, XLSX, PPTX, HTML to PDF
  • Convert DOC, XLS, PPT to DOCX, XLSX, PPTX
  • Extract data from fillable PDF forms
  • Protect PDF files
  • Add watermarks
  • Split PDF
  • Merge PDF
  • Compress PDF
  • Read CSV files
  • Convert CSV files to Excel
  • Extract data using regular expressions
  • Fill merge fields in DOCX document
  • Value properties in DOCX, XLSX and PPTX templates
  • Operations in DOCX, XLSX and PPTX templates
Documentation › Excel XLSX templates › Links

Links

The templating engine allows you to add dynamic hyperlinks to a location on the web.

You can download the source document and the result document for the example described below in links demo.

Let us assume we have a list of online learning resources.

JSON representation of the object:

[
    {
        "name": "Coursera",
        "type": "Commercial",
        "headquarters": "USA",
        "linkName": "Go to the site",
        "linkURL": "https://plato.stanford.edu/"
    },
    {
        "name": "edX",
        "type": "Non-profit",
        "headquarters": "USA",
        "linkName": "Go to the site",
        "linkURL": "https://www.edx.org/"
    },
    {
        "name": "FutureLearn",
        "type": "Commercial",
        "headquarters": "UK",
        "linkName": "Go to the site",
        "linkURL": "https://www.futurelearn.com/"
    }
]

Now, let us take a look at the source template for this structure:

External links template

We designed a table with a header and just one row that contains our tags. The templating engine is smart enough to understand what content needs to be duplicated.

To refer properties of the objects we just used the names of the properties:

{{name}}, {{type}}, {{headquarters}}, {{linkName}}, {{linkURL}}.

To create a hyperlink to a location on the web we select a tab where we want to display our hyperlink, in the Insert tab in MS Word, click Link, navigate to the Existing File or Web Page tab and add a tag into the Text to display and Address fields:

Insert hyperlink: URL

You can see the result of rendering below. The templating engine created web hyperlinks in the document:

External links result
Previous
Tables in XLSX templates
Next
Loops and nesting in XLSX templates