Class ExcelHyperLink
HyperlinkClass
Inherited Members
Namespace: OfficeOpenXml
Assembly: EPPlus.dll
Syntax
public class ExcelHyperLink : Uri, ISpanFormattable, IFormattable, ISerializable
Constructors
ExcelHyperLink(string)
A new hyperlink with the specified URI
Declaration
public ExcelHyperLink(string uriString)
Parameters
| Type | Name | Description |
|---|---|---|
| string | uriString | The URI |
ExcelHyperLink(string, string)
Sheet internal reference.
Declaration
public ExcelHyperLink(string referenceAddress, string display)
Parameters
| Type | Name | Description |
|---|---|---|
| string | referenceAddress | The address or defined name |
| string | display | Displayed text |
ExcelHyperLink(string, UriKind)
A new hyperlink with the specified URI and kind
Declaration
public ExcelHyperLink(string uriString, UriKind uriKind)
Parameters
| Type | Name | Description |
|---|---|---|
| string | uriString | The URI |
| UriKind | uriKind | Kind (absolute/relative or indeterminate) |
Properties
ColSpan
If the hyperlink spans multiple columns
Declaration
public int ColSpan { get; set; }
Property Value
| Type | Description |
|---|---|
| int |
Display
Displayed text
Declaration
public string Display { get; set; }
Property Value
| Type | Description |
|---|---|
| string |
OriginalUri
Used to handle non absolute URI's. Is used if IsAblsoluteUri is true. The base URI will have a dummy value of xl://nonAbsolute.
Declaration
public Uri OriginalUri { get; }
Property Value
| Type | Description |
|---|---|
| Uri |
ReferenceAddress
The Excel address for internal links or extended data for external hyper links not supported by the Uri class.
Declaration
public string ReferenceAddress { get; set; }
Property Value
| Type | Description |
|---|---|
| string |
RowSpan
If the hyperlink spans multiple rows
Declaration
public int RowSpan { get; set; }
Property Value
| Type | Description |
|---|---|
| int |
ToolTip
Tooltip
Declaration
public string ToolTip { get; set; }
Property Value
| Type | Description |
|---|---|
| string |