Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Current »

Represents a hyperlink in an Area (which may contain only one cell) that points to an external URL.

C#
vb.net

To create a Hyperlink object, call Cell.CreateHyperlink or Area.CreateHyperlink. To get an existing Hyperlink, use Worksheet.Hyperlinks.

A Hyperlink only represents a URL to an external resource such as a web site. To create a link to another location in the workbook, you will need to use Excel's Hyperlink formula. You will need to surround the destination cell in quotes and preface it with a pound sign. For example, a cell with formula =HYPERLINK("#DestinationWorksheet!B3", "Link to B3") will contain the text "Link to B3", and if you click on that text it will bring you to cell B3 on the worksheet named DestinationWorksheet.

C#
vb.net

Name

Description

Area

Returns the Area that the Hyperlink object is associated with. The set of cells that the Area object represents functions as a single hyperlink to the same href.

Href

Sets or returns the URL that the hyperlink links to.

Text

Sets or returns the hyperlink's displayed text.
  • No labels