Add a hyperlink to a cell.
Add a hyperlink to a cell to point to an external resource.
addHyperlink(
cell,
address,
linkType = c("URL", "DOCUMENT", "EMAIL", "FILE"),
hyperlinkStyle = NULL
)The cell needs to have content before you add a hyperlink to it. The contents of the cells don't need to be the same as the address of the hyperlink. See the examples.
None. The modification to the cell is done in place.
Adrian Dragulescu
wb <- createWorkbook() sheet1 <- createSheet(wb, "Sheet1") rows <- createRow(sheet1, 1:10) # 10 rows cells <- createCell(rows, colIndex=1:8) # 8 columns ## Add hyperlinks to a cell cell <- cells[[1,1]] address <- "https://poi.apache.org/" setCellValue(cell, "click me!") addHyperlink(cell, address) # Don't forget to save the workbook ...
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.