Apache POI Hyperlink

by Online Tutorials Library July 14, 2022

Apache POI Hyperlink

Apache POI allows us to create hyperlink in spreadsheet. It is useful to set web addresses in the cell and redirect to the server when clicked.

See, in the below example where we have created hyperlink that redirects to the tutoraspire.com

Apache POI Hyperlink Example

  package poiexample;  import java.io.FileOutputStream;  import java.io.IOException;  import org.apache.poi.hssf.usermodel.HSSFCell;  import org.apache.poi.hssf.usermodel.HSSFRow;  import org.apache.poi.hssf.usermodel.HSSFSheet;  import org.apache.poi.hssf.usermodel.HSSFWorkbook;  import org.apache.poi.ss.usermodel.CellType;  public class HyperlinkFormula {   public static void main(String[] args) throws IOException {   try (HSSFWorkbook wb = new HSSFWorkbook()) {           HSSFSheet sheet = wb.createSheet(“new sheet”);           HSSFRow row = sheet.createRow(0);           HSSFCell cell = row.createCell(0);           cell.setCellType(CellType.FORMULA);           cell.setCellFormula(“HYPERLINK(“http://https://tutoraspire.com/apache-poi-tutorial”, “click here”)”);           try (FileOutputStream fileOut = new FileOutputStream(“tutoraspire.xls”)) {               wb.write(fileOut);           }       }   }  }  

Output:

Next TopicApache POI Microsoft Word

Apache POI Hyperlink

Apache POI Hyperlink

Apache POI Hyperlink Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like