Add Hyperlinks to Excel in Java
Tags: java, excel, hyperlink
Published: 2020-03-06 07:41:01

---
title: Add Hyperlinks to Excel in Java
published: true
description: This article shows you how to create text and image hyperlinks in  Excel cells in Java.
tags: java,excel,hyperlink
---

In an Excel worksheet, you can create a hyperlink based on text or an image in any cell. Then, click that hyperlink to go to the specificed location. In this article, I’ll share with you how to add a hyperlink in a cell that links to a website, an email address, an ip address, an external file or a cell in anther worksheet, by using Free Spire.XLS for Java.

##Add Spire.Xls.jar as dependency

Method 1: Download [Free Spire.XLS for Java](https://www.e-iceblue.com/Download/xls-for-java-free.html) pack, unzip it and you’ll get Spire.Doc.jar file from the “lib” folder. Import the jar file in your project as a denpendency.

Method 2:  If you are creating a Maven project, you can easily add the jar dependency by adding the following configurations to the pom.xml.
```java
<repositories>
        <repository>
            <id>com.e-iceblue</id>
            <name>e-iceblue</name>
            <url>http://repo.e-iceblue.com/nexus/content/groups/public/</url>
        </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId> e-iceblue </groupId>
        <artifactId>spire.xls.free</artifactId>
        <version>2.2.0</version>
    </dependency>
</dependencies>
```
##Add text hyerplinks
```java
import com.spire.xls.*;

public class InsertTextHyperlinks {

    public static void main(String[] args) {

        //Create a Workbook object
        Workbook workbook = new Workbook();

        //Get the first worksheet
        Worksheet sheet = workbook.getWorksheets().get(0);

        //Add a link to B3 that links to a website
        HyperLink urlLink = sheet.getHyperLinks().add(sheet.getCellRange("B3"));
        urlLink.setTextToDisplay("Link to a website");
        urlLink.setAddress("http://www.google.com");

        //Add a link to E3 that links to an email address
        HyperLink mailLink = sheet.getHyperLinks().add(sheet.getCellRange("E3"));
        mailLink.setTextToDisplay("Link to an email address");
        mailLink.setAddress("mailto:abc@outlook.com");

        //Add a link to B7 that links to an external file
        HyperLink fileLink = sheet.getHyperLinks().add(sheet.getCellRange("B7"));
        fileLink.setTextToDisplay("Link to an external file");
        fileLink.setAddress("C:\\Users\\Administrator\\Desktop\\Report.doc");

        //Add a link to E7 that links to a cell in antoher sheet
        HyperLink linkToSheet = sheet.getHyperLinks().add(sheet.getCellRange("E7"));
        linkToSheet.setTextToDisplay("Link to a cell in sheet2");
        linkToSheet.setAddress("Sheet2!B5");

        //Add a link to B11 that links to an ip address
        HyperLink uncLink = sheet.getHyperLinks().add(sheet.getCellRange("B11"));
        uncLink.setTextToDisplay("Link to an ip address");
        uncLink.setAddress("\\\\192.168.1.108");

        //Save to file
        workbook.saveToFile("AddTextHyperlinks.xlsx", ExcelVersion.Version2013);
    }
}
```
Ouput
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/ybf2mgunu86hsixdogg0.png)
##Add an image hyperlink
```java
import com.spire.xls.*;

public class InsertImageHyperlink {

    public static void main(String[] args) {

        //Create a Workbook instance and get the first worksheet 
        Workbook wb = new Workbook();
        Worksheet sheet = wb.getWorksheets().get(0);

        //Insert an image to the cell C5
        String picPath = "C:\\Users\\Administrator\\Desktop\\home_button.png";
        ExcelPicture picture = sheet.getPictures().add(5,3,picPath);

        //Set a hyperlink for the image 
        picture.setHyperLink("Http://www.google.com", true);

        //Set column width and row height/ 
        sheet.getColumns()[2].setColumnWidth(21);
        sheet.getRows()[4].setRowHeight(36);

        //Save the document 
        wb.saveToFile("AddImageHyperlink.xlsx", ExcelVersion.Version2016);
    }
}
```
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/owm5wqr0ptwbo7pxl0dv.png)