Interface IHyperlink

ReadonlyisIHyperlink

getAddress

• getAddress(): string

  This can be a url or a cell address.

  Returns string

  Remarks

  A sheet address needs to start with a #.

getDisplayText

• getDisplayText(): string

  This is either the address or the cell value.

  Returns string

getTarget

• getTarget(): string

  Specified the target frame when opening this Hyperlink.

  Returns string

  Default Value

  newWindow

getTooltip

• getTooltip(): string

  Tet for showing addition information about the link that will be displayed as a tooltip.

  Returns string

  Remarks

  Excel has an undocumented tooltip length limit of 255 characters.

open

• open(target?: "_self" | "_blank", features?: string): Promise<boolean>

  Open the hyperlink.

  Parameters

  • Optionaltarget: "_self" | "_blank"

    Specifies where to open the linked document. DefaultValue getTarget().
  • Optionalfeatures: string

    Passed to the window open context for external resource.

  Returns Promise<boolean>

  See

  MDN Reference