makeHyperlinkString: create Excel hyperlink string
Description
Wrapper to create internal hyperlink string to pass to writeFormula()
Usage
makeHyperlinkString(sheet, row = 1, col = 1, text = NULL, file = NULL)
Arguments
row
integer row number for hyperlink to link to
col
column number of letter for hyperlink to link to
file
Excel file name to point to. If NULL hyperlink is internal.