WorksheetHyperlink Constructor(String,Object,String,String)

Creates a new WorksheetHyperlink instance.

Syntax

C#

public WorksheetHyperlink( 
   string sourceAddress,
   object target,
   string displayText,
   string toolTip
)

Parameters

sourceAddress

The address of the cell or region on which the hyperlink should reside.

target

The target of the hyperlink, which can be a string, WorksheetCell, WorksheetRegion, or NamedReference instance. For bookmarks in an external document, separate the sub-address with a #, such as "File.xlsx#Sheet1!C3". For email addresses, use a target string with the format "mailto:[e-mail]" or "mailto:[e-mail]?subject=Email%20Subject".

displayText

The text to display in the cell when the hyperlink is added to a worksheet, or null to use the target text.

toolTip

The text to use in a tool tip when hovering over the source cell or region, or null to use the default tool tip.

Exceptions

Exception	Description
System.ArgumentNullException	Occurs when sourceAddress is null.
System.ArgumentException	Occurs when target is not a string, WorksheetCell, WorksheetRegion, or NamedReference instance.
System.ArgumentException	Occurs when target is a string longer than 256 characters.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+