//A link to a URL File sdDir = Environment.getExternalStorageDirectory(); String sdPath = sdDir.getCanonicalPath(); //Instantiating a Workbook object Workbook workbook = new Workbook(); //Obtaining the reference of the first worksheet. WorksheetCollection worksheets = workbook.getWorksheets(); Worksheet sheet = worksheets.get(0); HyperlinkCollection hyperlinks = sheet.getHyperlinks(); //Adding a hyperlink to a URL at "A1" cell hyperlinks.add("A1",1,1,"http://www.aspose.com"); //Saving the Excel file workbook.save(sdPath + "/book1.xls"); //In the above example, a URL is added to an empty cell, A1, as a hyperlink. When the cell is empty, the URL also becomes the link text. If a URL is added as a link to a cell that already contains text, then the hyperlink is added but the value of the cell looks like plain text. To make it look like a hyperlink, apply formatting on the cell. File sdDir = Environment.getExternalStorageDirectory(); String sdPath = sdDir.getCanonicalPath(); //Instantiating a Workbook object Workbook workbook = new Workbook(); //Obtaining the reference of the first worksheet. WorksheetCollection worksheets = workbook.getWorksheets(); Worksheet sheet = worksheets.get(0); //Setting a value to the "A1" cell Cells cells = sheet.getCells(); Cell cell = cells.get("A1"); cell.setValue("Visit Aspose"); //Setting the font color of the cell to Blue Style style = cell.getStyle(); style.getFont().setColor(Color.getBlue()); //Setting the font of the cell to Single Underline style.getFont().setUnderline(FontUnderlineType.SINGLE); cell.setStyle(style); HyperlinkCollection hyperlinks = sheet.getHyperlinks(); //Adding a hyperlink to a URL at "A1" cell hyperlinks.add("A1",1,1,"http://www.aspose.com"); //Saving the Excel file workbook.save(sdPath + "/book1.xls"); //Adding a Link to another Cell in the Same File File sdDir = Environment.getExternalStorageDirectory(); String sdPath = sdDir.getCanonicalPath(); //Instantiating a Workbook object Workbook workbook = new Workbook(); //Obtaining the reference of the first worksheet. WorksheetCollection worksheets = workbook.getWorksheets(); Worksheet sheet = worksheets.get(0); //Setting a value to the "A1" cell Cells cells = sheet.getCells(); Cell cell = cells.get("A1"); cell.setValue("Visit Aspose"); //Setting the font color of the cell to Blue Style style = cell.getStyle(); style.getFont().setColor(Color.getBlue()); //Setting the font of the cell to Single Underline style.getFont().setUnderline(FontUnderlineType.SINGLE); cell.setStyle(style); HyperlinkCollection hyperlinks = sheet.getHyperlinks(); //Adding an internal hyperlink to the "B9" cell of the other worksheet "Sheet2" in //the same Excel file hyperlinks.add("B3",1 ,1, "Sheet2!B9"); //Saving the Excel file workbook.save(sdPath + "/book1.xls"); //Adding a Link to an External File File sdDir = Environment.getExternalStorageDirectory(); String sdPath = sdDir.getCanonicalPath(); //Instantiating a Workbook object Workbook workbook = new Workbook(); //Obtaining the reference of the first worksheet. WorksheetCollection worksheets = workbook.getWorksheets(); Worksheet sheet = worksheets.get(0); //Setting a value to the "A1" cell Cells cells = sheet.getCells(); Cell cell = cells.get("A1"); cell.setValue("Visit Aspose"); //Setting the font color of the cell to Blue Style style = cell.getStyle(); style.getFont().setColor(Color.getBlue()); //Setting the font of the cell to Single Underline style.getFont().setUnderline(FontUnderlineType.SINGLE); cell.setStyle(style); HyperlinkCollection hyperlinks = sheet.getHyperlinks(); //Adding a link to the external file hyperlinks.add("A5", 1, 1, "C:\\book1.xls"); //Saving the Excel file workbook.save(sdPath + "/book2.xls");