SheetXL - v0.8.0-beta.9+sites.210.e2d420901
    Preparing search index...

    Function toHyperlinkAddress

    • The hyperlink address for text that Excel's AutoCorrect would turn into a link, or null when the text is not link-shaped.

      Parameters

      • text: string

        The text to check.

      Returns string | null

      The address, with the scheme Excel supplies when the text omits one, or null.

      Mirrors Excel's "Internet and network paths with hyperlinks" rule, which links:

      • http(s)://… - as is.
      • www.… - as http://www.….
      • mailto:… - as is.
      • an email address - as mailto:….

      A bare domain (sheetxl.com) is left alone, as Excel leaves it.