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

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 {=HYPERLINK("Sheet1!C3", "Link to C3")}, {code:csharp|title=C#} cellA1.Formula = "=HYPERLINK(\"Sheet1!C3\", \"Link to C3\")"; {code} {code:vb.net|title=vb.net} TODO {code}

Excerpt
Wiki Markup

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")

...