Represents a hyperlink for a cell or region.

Inheritance

constructor

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

Returns WorksheetHyperlink

constructor

public WorksheetHyperlink(WorksheetRegion sourceRegion, object target, string displayText = null, string toolTip = null)

Returns WorksheetHyperlink

constructor

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

Returns WorksheetHyperlink

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

public string DisplayText { get; set; }

Gets the value indicating whether the hyperlink is sealed and cannot be modified.

public bool IsSealed { get; }

Gets or sets the address of the cell or region on which the hyperlink resides.

public string SourceAddress { get; set; }

Gets or sets the cell on which the hyperlink resides.

public WorksheetCell SourceCell { get; set; }

Gets or sets the region on which the hyperlink resides.

public WorksheetRegion SourceRegion { get; set; }

Gets or sets the target of the hyperlink, which can be a string, , , or 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:joe" or "mailto:joe".

public object Target { get; set; }

Gets or sets the target address of the hyperlink. 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:joe" or "mailto:joe".

public string TargetAddress { get; set; }

Gets or sets the target cell of the hyperlink.

public WorksheetCell TargetCell { get; set; }

Gets or sets the target named reference of the hyperlink.

public NamedReference TargetNamedReference { get; set; }

Gets or sets the target region of the hyperlink.

public WorksheetRegion TargetRegion { get; set; }

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

public string ToolTip { get; set; }

Gets the worksheet to which the hyperlink belongs.

public Worksheet Worksheet { get; }

Gets the string representation of the hyperlink.

public override string ToString()

Returns any