EasyXLS

How to add hyperlinks in ColdFusion

EasyXLS Excel library can be used to export Excel files in ColdFusion. The library works without MS Excel installed.

Step 1: Download EasyXLS Excel Library for Java

To download the trial version of EasyXLS Excel Library, press the below button:

Download EasyXLS™ Excel Library for Coldfusion

If you already own a license key, you may login and download EasyXLS from your account.

Install the downloaded EasyXLS installer for v8.6 or earlier.

Step 2: License file setup

Step required for EasyXLS v9.0 or later.

If you are using a trial, generate a trial license file from EasyXLS trials page. The trial license is valid for 30-days.

If you own a license key, you may login to the account that purchased the license and generate the license file from:
https://www.easyxls.com/my-orders

Setup the license file into your project using these guidelines.

Step 3: Add EasyXLS library to CLASSPATH in ColdFusion Administator

EasyXLS.jar must be included to class path for Java runtime environment.

EasyXLS.jar can be found:
- Inside the downloaded archive at Step 1 for EasyXLS v9.0 or later
- Under installation path for EasyXLS v8.6 or earlier, in "Lib" folder.

Add EasyXLS library to CLASSPATH

Another solution is to add EasyXLS.jar to "lib" folder from ColdFusion installation path.

Step 4: Run ColdFusion code that adds hyperlinks to Excel

Execute the following ColdFusion code that exports an Excel file with hyperlinks on a cell or cell ranges.

<!--
===================================================================================
Tutorial 15

This tutorial shows how to create an Excel file with hyperlinks in Java.

EasyXLS supports the following hyperlink types:
   (1) - hyperlink to URL
   (2) - hyperlink to file
   (3) - hyperlink to UNC
   (4) - hyperlink to cell in the same Excel file
   (5) - hyperlink to name

Every type of hyperlink accepts a tool tip description.

Every type of hyperlink accepts a text mark. A text mark is a link inside the file.
===================================================================================
-->

<!-- Constants Classes -->
<cfobject type="java" class="EasyXLS.Constants.HyperlinkType" name="HyperlinkType" action="CREATE">

Tutorial 15<br>
----------<br>

<!-- Create an instance of the class that exports Excel files -->
<cfobject type="java" class="EasyXLS.ExcelDocument" name="workbook" action="CREATE">

<!-- Create two worksheets -->
<cfset ret = workbook.easy_addWorksheet("First tab")>
<cfset ret = workbook.easy_addWorksheet("Second tab")>

<cfset xlsTab1 = workbook.easy_getSheetAt(0)>
<cfset xlsTab2 = workbook.easy_getSheetAt(1)>

<!-- Create hyperlink to URL -->
<cfset xlsTab1.easy_addHyperlink(HyperlinkType.URL, "https://www.easyxls.com", "Link to URL", "B2:E2")>

<!-- Create hyperlink to file -->
<cfset xlsTab1.easy_addHyperlink(HyperlinkType.FILE, "c:\myfile.xls", "Link to file", "B3")>

<!-- Create hyperlink to UNC -->
<cfset xlsTab1.easy_addHyperlink(HyperlinkType.UNC, "\\computerName\Folder\file.txt", "Link to UNC", "B4:D4")>

<!-- Create hyperlink to cell on second sheet -->
<cfset xlsTab1.easy_addHyperlink(HyperlinkType.CELL, "'Second tab'!D3", "Link to CELL", "B5")>

<!-- Create a name on the second sheet -->
<cfset xlsTab2.easy_addName("Name", "=Second tab!$A$1:$A$4")>
        
<!-- Create hyperlink to name -->
<cfset xlsTab1.easy_addHyperlink(HyperlinkType.CELL, "Name", "Link to a name", "B6")>

<!-- Export Excel file -->
Writing file C:\Samples\Tutorial15 - hyperlinks in Excel.xlsx<br>
<cfset ret = workbook.easy_WriteXLSXFile("C:\Samples\Tutorial15 - hyperlinks in Excel.xlsx")>

<!-- Confirm export of Excel file -->
<cfset sError = workbook.easy_getError()>
<cfif (sError is "")>
    <cfoutput>
        File successfully created.
    </cfoutput>
<cfelse>
    <cfoutput>
        Error encountered: #sError#
    </cfoutput>
</cfif>

<!-- Dispose memory -->
<cfset workbook.Dispose()>

EasyXLS Excel libraries:

Java
Excel Library for ColdFusion
full Java version to import, export or convert Excel files
Excel Writer for ColdFusion
Java version to create and export Excel files
Download EasyXLS™ Excel Library for ColdFusion

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2019
MS Excel 2021
Office 365
XLSXXLSMXLSBXLS
XMLHTMLCSVTXT