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, System.String text)
{signature}{signature:
}
Signature
vb.net
vb.net
Public Function CreateHyperlink(ByVal area As Area, ByVal href As String, ByVal text 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}
{param:text}The text to display in the link.{param}
{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.

Param
text
text

The text to display in the link.

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} {returns}A new [Hyperlink|Hyperlink] object with the specified destination URL and display text.{returns} {example}{code:csharp|title=C#}

Returns

A new Hyperlink object with the specified destination URL and display text.

Example
Code Block
csharp
csharp
titleC#

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

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