Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Excerpt

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.

Creating hyperlinks to other cells within the workbook are not supported. However, you may use a hyperlink formula to achieve the same functionality. For example, given the formula

Code Block
=HYPERLINK("Sheet1!C3", "Link to C3")

,

Code Block
csharpcsharp
titleC#

cellA1.Formula = "=HYPERLINK(\"Sheet1!C3\", \"Link to C3\")";
Code Block
vb.netvb.net
titlevb.net

TODO

Signature
C#
C#
 public Hyperlink CreateHyperlink(System.String href)

...

Param
href
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.

Example
Code Block
csharp
csharp
titleC#
Hyperlink link = cellA1.CreateHyperlink("http://www.softartisans.com");
Code Block
vb.net
vb.net
titlevb.net
Dim link As Hyperlink = cellA1.CreateHyperlink("http://www.softartisans.com")

...