Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


...


Please note that the 
Note
titleDeprecation notice
Parameters removed
  • The URL user and URL user password parameters
are deprecated and will be removed on March 31, 2022. We recommend using profiles to access your data from remote locations.
  • have been removed from Excel for Confluence. For more information, refer to Removed the URL user and URL user password parameters.
  • Use Profiles to access Excel data from remote locations.
  • Parameter removal is effective and available in: Excel for Confluence - Server (version 7.3.0 and above)

Description

This article illustrates how to create a profile using a URL in the Excel macro.

Info

Before you begin:

  • Before you enter the URL for a repository, ensure that it is a raw URL.
    A raw URL is defined as the part of the URL following the domain information and includes the query string, if present. For example, in the URL string http://www.contoso.com/articles/recent.aspx, the raw URL is /articles/recent.aspx

    Tip
    titleHow to identify if a file is valid for the macro?

    Paste the file link into your browser's address bar. If the actual code is displayed in the browser, it is considered to be invalid or in an incorrect format. If the file downloads to your system, the macro can process the file and its contents.


  • Know what is a complete URL.
    • The complete URL, in this example, looks like: 
      https://bitbucket.org/bobswift-test/testfiles/raw/1366d872db9bef51f030a36c94a6b19ba5079c33/SheetJSTableExport.xlsx
  • For illustrative purposes, a public Bitbucket public repository is usedUse URLs to add to profiles and in macros as per your requirement and your instance. The process for adding a profile and using it in macros remains the same for other repositories and external sources.

...

You can work with URLs in two ways where you can:

Anchor
xl_URLProfile_absURL
xl_URLProfile_absURL
Use an absolute URL

...