OfficeWriter Documentation
.
ExcelWriter v11 Docs
Space Shortcuts
Page tree
ConfigureSpace tools
Skip to end of metadata
Go to start of metadata

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