Insert hyperlinks

Function for inserting hyperlinks within an openxlsx Workbook. Provides support for links to external .xlsx.

insert_hyperlinks(wb, sheetname, text, where, start_row = 15, file = NULL)

Arguments

wb

workbook object to add new worksheet to.

sheetname

Names of sheets to create hyperlinks to

text

Text to display in the cell with the hyperlink

where

Name of the worksheet where the hyperlinks should be inserted

start_row

First row from which hyperlink should be inserted

file

External file. Default: NULL