WorksheetHyperlink Constructor(WorksheetCell,Object,String,String)

Creates a new WorksheetHyperlink instance.

Syntax

C#

public WorksheetHyperlink( 
   WorksheetCell sourceCell,
   object target,
   string displayText,
   string toolTip
)

Parameters

sourceCell

The cell 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 sourceCell 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.
System.ArgumentException	Occurs when target is a cell, region, or named reference which is not from the same workbook as sourceCell.

Requirements

Target Platforms: Android 4.4+, iOS 8+

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