To download the trial version of EasyXLS Excel Library, press the below button:
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.
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()>