Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Description

Excerpt

Creates a new hyperlink in the area pointing to the specified href. This hyperlink is automatically added to the worksheet. All cell values in the area will be converted to hyperlinks.

Signature
C#C#
Wiki Markup
{description}
{excerpt}Creates a new hyperlink in the area pointing to the specified href. This hyperlink is automatically added to the worksheet. All cell values in the area will be converted to hyperlinks.
{excerpt}
{signature:C#}
 public Hyperlink CreateHyperlink(System.String href)
Signature
{signature}{signature:vb.net
vb.net
}
Public Function CreateHyperlink(ByVal href As String) As Hyperlink
Parameters
Param
hrefhrefThe
{signature}
{parameters}
{param:href}The hyperlink's destination.
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
{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 {{=HYPERLINK("#Sheet1!C3", "Link to C3")}}. Setting [Cell.Formula] with this formula will create the internal hyperlink.
Returns

A Hyperlink object.


{remarks}
{returns}A [Hyperlink|Hyperlink] object.{returns}
{example}{code:csharp|title=C#}
Hyperlink link = a.CreateHyperlink("http://www.softartisans.com");
{code}
{code:vbnet|title=vb.net
}
Dim link As Hyperlink = a.CreateHyperlink("http://www.softartisans.com")
Example
Code Block
csharpcsharp
titleC#
Code Block
vbnetvbnettitle

...

{code}

{example}
{scrollbar}