Description
Creates a new hyperlink in the specified area of cells. All cell values in the area will be converted to hyperlinks.
Creating a hyperlink to another cell or range within the workbook is not supported. However, you may use a hyperlink formula to achieve the same functionality. For example, to link to cell C3 you would use the formula =HYPERLINK("#Sheet1!C3", "Link to C3")
. Setting Cell.Formula with this formula will create the internal hyperlink.
C#
vb.net
Parameters
area
An Area object representing the cells that will be converted to hyperlinks.href
The hyperlink's destination.Returns
A new Hyperlink object with the specified destination URL.Examples
C#
vb.net