Add a hyperlink to a content of the cell using Java and Apache POI. Apache POI is a Java library that is used to handle Microsoft Office Documents.
Installation:
There are two ways to install the Apache POI dependency in our java project:
- Download below mentioned Jar files from poi.apache.org/download.html:
- Maven Dependency: Set the following dependency in the maven project as:
<dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.9</version> </dependency>
Environment Setup:
- Make a project Using java maven.
- Go to poi.apache.org/download.html and add the dependency into your project. By this, the libraries get imported into your project.
- Now, make a java class under com.mycompany.<Your Project Name> in Source Packages.
- Nice, now you can use the libraries.
Approach:
- Create a workbook.
- Create a spreadsheet in workbook.
- Create a cell and add color, content and styling to it.
- Add the address and apply the link colors to it.
- Add cell in spreadsheet.
- Repeat step 3 to 5 to write more data
Below is the implementation of the above approach:
Java
// How to add hyperlink to the // contents of a cell using Java? import java.io.File;
import java.io.FileOutputStream;
import org.apache.poi.common.usermodel.Hyperlink;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFFont;
import org.apache.poi.xssf.usermodel.XSSFHyperlink;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class HyperLink {
public static void addLink()
{
// Create a Workbook
XSSFWorkbook myWorkbook = new XSSFWorkbook();
// Create a Spread Sheet
XSSFSheet newSpreadsheet
= myWorkbook.createSheet( "Custom Links" );
XSSFCell cell;
// Create Helpers
CreationHelper helper
= myWorkbook.getCreationHelper();
XSSFCellStyle linkStyle
= myWorkbook.createCellStyle();
XSSFFont linkFont = myWorkbook.createFont();
// Setting the Link Style
linkFont.setUnderline(XSSFFont.U_SINGLE);
linkFont.setColor(HSSFColor.BLUE.index);
linkStyle.setFont(linkFont);
// Adding a Link
cell = newSpreadsheet.createRow( 1 ).createCell(
( short ) 2 );
cell.setCellValue( "Link" );
XSSFHyperlink link
= (XSSFHyperlink)helper.createHyperlink(
Hyperlink.LINK_URL);
cell.setHyperlink((XSSFHyperlink)link);
cell.setCellStyle(linkStyle);
// Writing the File
FileOutputStream output = new FileOutputStream(
new File( "C:/HyperLink.xlsx" ));
// Writing the content
myWorkbook.write(output);
output.close();
}
public static void main(String[] args) throws Exception
{
addLink();
}
} |
Output:
Article Tags :
Recommended Articles