Cell.CreateHyperlink(String)

Description

Creates a new hyperlink in the cell pointing to the specified href. This hyperlink is automatically added to the worksheet. The cell value will be converted to hyperlinks.

C#

public Hyperlink CreateHyperlink(System.String href)

vb.net

Public Function CreateHyperlink(ByVal href As String) As Hyperlink

Parameters

href

The hyperlink's destination.

Returns

A Hyperlink object.

Remarks

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.

Examples

C#

Hyperlink link = cellA1.CreateHyperlink("http://www.softartisans.com");