Insert hyperlinks with titles and sheetnames

Function for inserting hyperlinks within an openxlsx Workbook

insert_index_hyperlinks(
  wb,
  sheetname,
  title,
  index_sheet_name = "Index",
  sheet_start_row = 15
)

Arguments

wb

workbook object to add new worksheet to.

sheetname

Names of sheets to create hyperlinks to

title

Titles of Hyperlinks

index_sheet_name

Name of sheet where hyperlink should be created

sheet_start_row

Initial row after which hyperlinks should be created