@Override public Hyperlink createHyperlink(HyperlinkType type) { return helper.createHyperlink(type); } @Override
@Override public void applyStyleAndValue(int dbColNum, ResultSet resultSet, Cell cell) throws SQLException { if (links < MAX_HYPERLINKS) { Hyperlink hyperlink = workbook.getCreationHelper().createHyperlink(linkType); String path = resultSet.getString(dbColNum); String address = urlBase+path; hyperlink.setAddress(address); cell.setHyperlink(hyperlink); cell.setCellStyle(style); String fName = Paths.get(path).getFileName().toString(); cell.setCellValue(fName); links++; } else { //silently stop adding hyperlinks } } }
@Override public Hyperlink createHyperlink(HyperlinkType type) { return helper.createHyperlink(type); } @Override
private void createCellHyperLink(Cell cell, EntityInfo eInfo, Object val, XSSFWorkbook workbook) { CellStyle style = workbook.createCellStyle(); Font font = workbook.createFont(); font.setUnderline(Font.U_SINGLE); font.setColor(HSSFColor.BLUE.index); style.setFont(font); XSSFHyperlink hLink = null; if(EMAIL.equals(eInfo.getSemantics())){ hLink = workbook.getCreationHelper().createHyperlink(HyperlinkType.EMAIL); hLink.setAddress("mailto:"+String.valueOf(val)); }else if(URL.equals(eInfo.getSemantics())){ hLink = workbook.getCreationHelper().createHyperlink(HyperlinkType.URL); hLink.setAddress(String.valueOf(val)); } if(hLink != null){ cell.setHyperlink(hLink); cell.setCellStyle(style); } }
//creating the cell Row row = my_sheet.createRow(0); Cell cell = row.createCell(0); //creating helper class XSSFWorkbook workbook = new XSSFWorkbook(); XSSFCreationHelper helper= workbook.getCreationHelper(); //creating the hyperlink link = helper.createHyperlink(HSSFHyperlink.LINK_DOCUMENT); link.setAddress("'target_worksheet_name'!A1"); //optional hyperlink style XSSFCellStyle hlinkstyle = workbook.createCellStyle(); XSSFFont hlinkfont = workbook.createFont(); hlinkfont.setUnderline(XSSFFont.U_SINGLE); hlinkfont.setColor(HSSFColor.BLUE.index); hlinkstyle.setFont(hlinkfont); //applying the hyperlink to the cell cell.setHyperlink(link);
hlink_style.setFont(hlink_font); XSSFHyperlink link = createHelper.createHyperlink(XSSFHyperlink.LINK_FILE); link.setAddress(url); cell.setHyperlink(link);
final XSSFHyperlink xssfHyperlink = helper.createHyperlink(Hyperlink.LINK_URL); xssfHyperlink.setAddress(cell.getFormattedValue()); xssfHyperlink.setLabel(cell.getLabel());
XSSFHyperlink hyperlink = creationHelper.createHyperlink( HyperlinkType.URL ); hyperlink.setAddress( getValue( (SimpleNode) node ) ); hyperlink.setLabel( getValue( (SimpleNode) node ) ); XSSFHyperlink hyperlink = creationHelper.createHyperlink( HyperlinkType.EMAIL ); hyperlink.setAddress( getValue( (SimpleNode) node ) ); hyperlink.setLabel( getValue( (SimpleNode) node ) );