package com.aspose.cells.examples.featurescomparison.datahandling.hyperlink;
import com.aspose.cells.Cell;
import com.aspose.cells.Cells;
import com.aspose.cells.Color;
import com.aspose.cells.FontUnderlineType;
import com.aspose.cells.HyperlinkCollection;
import com.aspose.cells.Style;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;
import com.aspose.cells.WorksheetCollection;
import com.aspose.cells.examples.Utils;
public class AsposeHyperlinks
{
public static void main(String[] args) throws Exception
{
// The path to the documents directory.
String dataDir = Utils.getDataDir(AsposeHyperlinks.class);
//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");
//============ Link to Cell =================
//Setting a value to the "A1" cell
Cells cells = sheet.getCells();
Cell cell = cells.get("A2");
cell.setValue("Link to B9");
setFormatting(cell);
hyperlinks = sheet.getHyperlinks();
//Adding an internal hyperlink to the "B9" cell of the other worksheet "Sheet1" in
//the same Excel file
hyperlinks.add("A2",1 ,1, "Sheet1!B9");
//============ Link to External File ========
cell = cells.get("A3");
cell.setValue("External Link");
setFormatting(cell);
hyperlinks = sheet.getHyperlinks();
//Adding a link to the external file
hyperlinks.add("A3", 1, 1, "book1.xls");
//Saving the Excel file
//workbook.save("c:\\book2.xls");
workbook.save(dataDir + "AsposeHyperlink.xls");
System.out.println("Done ...");
}
//=============================================================
private static void setFormatting(Cell cell)
{
//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);
}
}