Navigation

  • index
  • next |
  • previous |
  • Plumsail Documents Documentation »
  • Excel XLSX templates »

Getting started

  • Create documents from template
  • Use Zapier
  • Use Power Automate
  • Use Power Apps
  • Use as REST API

User guide

  • Processes
  • API Keys
  • Reports
  • Subscriptions
  • Account settings
  • Invite team members to account
  • Power Automate actions reference
  • REST API reference

Templates syntax

  • Word DOCX templates
  • Excel XLSX templates
    • How it works
    • Tables
    • Links
    • Loops and nesting
    • Formulas
    • Charts
    • Conditionally hide blocks
    • Automatic numbering
    • Merge cells vertically
    • Multiple worksheets
    • Aliases
    • Operations
    • Value formatters
    • Value properties
    • Update document metadata
    • Demos
  • PowerPoint PPTX templates
  • Fillable PDF
  • HTML templates
  • Value formatters in DOCX, XLSX and PPTX templates
  • Value properties in DOCX, XLSX and PPTX templates
  • Operations in DOCX, XLSX and PPTX templates
  • Aliases in DOCX, XLSX, and PPTX templates

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

General

  • Licensing details
  • Architecture
  • Data protection and security
  • Service level agreement

2000+ integrations

  • All
  • eSignature
  • Forms & Surveys
  • Sales & CRM
  • Commerce
  • Communication
  • Content & Files
  • Human Resources
  • Marketing automation
  • Analytics & Reporting
  • IT & Engineering
  • Productivity
  • Customer support
  • Your custom service
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

Navigation

  • index
  • next |
  • previous |
  • Plumsail Documents Documentation »
  • Excel XLSX templates »