2003 Files

Description Usage Arguments Details Value Author(s) Examples

Add a hyperlink to a cell to point to an external resource.

addHyperlink(
  cell,
  address,
  linkType = c("URL", "DOCUMENT", "EMAIL", "FILE"),
  hyperlinkStyle = NULL
)

`cell`	a `Cell` object.
`address`	a string pointing to the resource.
`linkType`	a the type of the resource.
`hyperlinkStyle`	a `CellStyle` object. If `NULL` a default cell style is created, blue underlined font.

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 ...