Add Hyperlinks to Excel in Java

In Excel, you can create a hyperlink to a web page, a file, an email address or create an image hyperlink. In this article, I’m going to show you how to add these hyperlinks to an Excel file programmatically in Java by using Free Spire.XLS for Java API.

Before using the following code, you need to download Free Spire.XLS for Java API, unzip the package and then add Spire.Xls.jar in the lib folder into your project. If you’re creating maven projects, you can install Free Spire.XLS for Java API from maven repository.

Add hyperlinks
import com.spire.xls.ExcelPicture;
import com.spire.xls.ExcelVersion;
import com.spire.xls.HyperLink;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;

public class AddHyperlinks {
    public static void main(String[] args) throws Exception {
        //Create a Workbook instance
        Workbook workbook = new Workbook();

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

        //Create a hyperlink to a web page
        HyperLink urlLink = sheet.getHyperLinks().add(sheet.getCellRange("B3"));
        urlLink.setTextToDisplay("Link to a web page");
        urlLink.setAddress("http://www.google.com");

        //Create a hyperlink to an email address
        HyperLink mailLink = sheet.getHyperLinks().add(sheet.getCellRange("B5"));
        mailLink.setTextToDisplay("Link to an email address");
        mailLink.setAddress("mailto:carol@outlook.com");

        //Create a hyperlink to a file
        HyperLink fileLink = sheet.getHyperLinks().add(sheet.getCellRange("B7"));
        fileLink.setTextToDisplay("Link to a file");
        fileLink.setAddress("Input.xlsx");

        //Create an image hyperlink
        String picPath = "logo.jpg";
        ExcelPicture picture = sheet.getPictures().add(10,2,picPath);
        picture.setWidth(120);
        picture.setHeight(60);
        //Set a hyperlink for the image
        picture.setHyperLink("Http://www.google.com", true);

        //Set column width
        sheet.setColumnWidth(2, 25);

        //Save to file
        workbook.saveToFile("AddHyperlinks.xlsx", ExcelVersion.Version2013);

    }
}

Output:

Comments

3 Ways to Generate Word Documents from Templates in Java

A template is a document with pre-applied formatting like styles, tabs, line spacing and so on. You can quickly generate a batch of documents with the same structure based on the template. In this article, I am going to show you the different ways to generate Word documents from templates programmatically in Java using Free Spire.Doc for Java library. Prerequisite First of all, you need to add needed dependencies for including Free Spire.Doc for Java into your Java project. There are two ways to do that. If you use maven, you need to add the following code to your project’s pom.xml file. <repositories> <repository> <id>com.e-iceblue</id> <name>e-iceblue</name> ...

Insert and Extract OLE objects in Word in Java

You can use OLE (Object Linking and Embedding) to include content from other programs, such as another Word document, an Excel or PowerPoint document to an existing Word document. This article demonstrates how to insert and extract embedded OLE objects in a Word document in Java by using Free Spire.Doc for Java API. Add dependencies First of all, you need to add needed dependencies for including Free Spire.Doc for Java into your Java project. There are two ways to do that. If you use maven, you need to add the following code to your project’s pom.xml file. <repositories> <repository> <id>com.e-iceblue</id> <name>e-iceblue</name> ...

Remove Duplicate Rows in Excel in C# and VB.NET

When an Excel file contains a huge amount of records, there might be duplicate records as well. In this blog, I am going to show you how to remove the duplicate rows in an Excel file programmatically in C# and VB.NET. The library I used: Free Spire.XLS for .NET Free Spire.XLS for .NET is a feature-rich Excel API offered by E-iceblue. It can be easily integrated in your .NET (C#, VB.NET, ASP.NET, .NET Core) applications to create, read, edit, convert and print Excel files without using Microsoft Office. Before coding, you need to get Free Spire.XLS for .NET by installing it via NuGet or downloading it via the official website . C# Code using Spire.Xls; using System.Linq; namespace RemoveDuplicateRows { class Program { static void Main( string [] args) ...

Office Dev Blogs

Search This Blog