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

Excerpt

Creates a new hyperlink in the specified area of cells. All cell values in the area will be converted to hyperlinks.

Signature
C#
C#
 public Hyperlink CreateHyperlink(Area area, System.String href)
{signature}{signature:
}
Signature
vb.net
vb.net
Public Function CreateHyperlink(ByVal area As Area, ByVal href As String) As Hyperlink
{signature}
{parameters}
{param:area}An [Area|Area] object representing the cells that will be converted to hyperlinks.{param}
{param:href}The hyperlink's destination.{param}
{returns}A new [Hyperlink|Hyperlink] object with the specified destination URL.{returns}
{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 {{
Parameters
Param
area
area

An Area object representing the cells that will be converted to hyperlinks.

Param
href
href

The hyperlink's destination.

Returns

A new Hyperlink object with the specified destination URL.

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.

{remarks} {example}{code:csharp|title=C#}

Example
Code Block
csharp
csharp
titleC#

links.CreateHyperlink(a, "http://www.softartisans.com");
{code} {code:
Code Block
vb.net
|title=
vb.net
titlevb.net
}

links.CreateHyperlink(a, "http://www.softartisans.com")
{code} {example}