Skip to end of metadata
Go to start of metadata

Description

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

C#
vb.net

Parameters

area
An Area object representing the cells that will be converted to hyperlinks.
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.

Examples

C#
vb.net
  • No labels