Class ExcelHyperLink

Namespace

OfficeOpenXml

Assembly

EPPlus.dll

HyperlinkClass

public class ExcelHyperLink : Uri, ISpanFormattable, IFormattable, ISerializable

Inheritance

object

Uri

ExcelHyperLink

Implements

ISpanFormattable

IFormattable

ISerializable

Inherited Members

Uri.UriSchemeFile

Uri.UriSchemeFtp

Uri.UriSchemeSftp

Uri.UriSchemeFtps

Uri.UriSchemeGopher

Uri.UriSchemeHttp

Uri.UriSchemeHttps

Uri.UriSchemeWs

Uri.UriSchemeWss

Uri.UriSchemeMailto

Uri.UriSchemeNews

Uri.UriSchemeNntp

Uri.UriSchemeSsh

Uri.UriSchemeTelnet

Uri.UriSchemeNetTcp

Uri.UriSchemeNetPipe

Uri.SchemeDelimiter

Uri.GetObjectData(SerializationInfo, StreamingContext)

Uri.CheckHostName(string)

Uri.GetLeftPart(UriPartial)

Uri.HexEscape(char)

Uri.HexUnescape(string, ref int)

Uri.IsHexEncoding(string, int)

Uri.CheckSchemeName(string)

Uri.IsHexDigit(char)

Uri.FromHex(char)

Uri.GetHashCode()

Uri.ToString()

Uri.TryFormat(Span<char>, out int)

Uri.Equals(object)

Uri.MakeRelativeUri(Uri)

Uri.MakeRelative(Uri)

Uri.Canonicalize()

Uri.Parse()

Uri.Escape()

Uri.Unescape(string)

Uri.EscapeString(string)

Uri.CheckSecurity()

Uri.IsReservedCharacter(char)

Uri.IsExcludedCharacter(char)

Uri.IsBadFileSystemCharacter(char)

Uri.TryCreate(string, UriKind, out Uri)

Uri.TryCreate(string, in UriCreationOptions, out Uri)

Uri.TryCreate(Uri, string, out Uri)

Uri.TryCreate(Uri, Uri, out Uri)

Uri.GetComponents(UriComponents, UriFormat)

Uri.Compare(Uri, Uri, UriComponents, UriFormat, StringComparison)

Uri.IsWellFormedOriginalString()

Uri.IsWellFormedUriString(string, UriKind)

Uri.UnescapeDataString(string)

Uri.EscapeUriString(string)

Uri.EscapeDataString(string)

Uri.IsBaseOf(Uri)

Uri.AbsolutePath

Uri.AbsoluteUri

Uri.LocalPath

Uri.Authority

Uri.HostNameType

Uri.IsDefaultPort

Uri.IsFile

Uri.IsLoopback

Uri.PathAndQuery

Uri.Segments

Uri.IsUnc

Uri.Host

Uri.Port

Uri.Query

Uri.Fragment

Uri.Scheme

Uri.OriginalString

Uri.DnsSafeHost

Uri.IdnHost

Uri.IsAbsoluteUri

Uri.UserEscaped

Uri.UserInfo

object.GetType()

object.MemberwiseClone()

object.Equals(object, object)

object.ReferenceEquals(object, object)

Constructors

ExcelHyperLink(string)

A new hyperlink with the specified URI

public ExcelHyperLink(string uriString)

Parameters

uriString string

The URI

ExcelHyperLink(string, string)

Sheet internal reference

public ExcelHyperLink(string referenceAddress, string display)

Parameters

referenceAddress string

The address or defined name

display string

Displayed text

ExcelHyperLink(string, UriKind)

A new hyperlink with the specified URI and kind

public ExcelHyperLink(string uriString, UriKind uriKind)

Parameters

uriString string

The URI

uriKind UriKind

Kind (absolute/relative or indeterminate)

Properties

ColSpan

If the hyperlink spans multiple columns

public int ColSpan { get; set; }

Property Value

int

Display

Displayed text

public string Display { get; set; }

Property Value

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.

public Uri OriginalUri { get; }

Property Value

Uri

ReferenceAddress

The Excel address for internal links or extended data for external hyper links not supported by the Uri class.

public string ReferenceAddress { get; set; }

Property Value

string

RowSpan

If the hyperlink spans multiple rows

public int RowSpan { get; set; }

Property Value

int

ToolTip

Tooltip

public string ToolTip { get; set; }

Property Value

string