//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); HyperLinkCellType cellType = new HyperLinkCellType(); cellType.setText("Google"); cellType.setLinkColor("Blue"); cellType.setLinkToolTip("Search by google"); cellType.setVisitedLinkColor("Green"); cellType.setTarget(HyperLinkTargetType.Blank); worksheet.getRange("C5").setCellType(cellType); worksheet.getRange("C5").setValue("http://www.google.com"); //save to an excel file workbook.save("AddHyperlinkCellType.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val cellType = HyperLinkCellType() cellType.setText("Goole") cellType.setLinkColor("Blue") cellType.setLinkToolTip("Search by google") cellType.setVisitedLinkColor("Green") cellType.target = HyperLinkTargetType.Blank worksheet.getRange("C5").cellType = cellType worksheet.getRange("C5").setValue("http://www.google.com") //save to an excel file workbook.save("AddHyperlinkCellType.xlsx")