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 a hyperlink to another cell 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.

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

...