Versions Compared

Key

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

This page illustrates how you can access your Excel files from a remote location directly using URLs in the Excel macro editor. 

Info

If you intend to access Excel files from a specific location, or, use the same file across multiple pages, it is recommended to use profiles.

Administrators create profiles which are a set of basic parameters used to access an external location. Users need only provide the relative path to the actual location of the files to be used with the specified profile. Refer to the documentation to know more about profiles and the macro's page to know how to use profiles and other parameters in your pages.

Define these parameters/values

Output format

html

Page of attachment

empty

Name of attachment

empty

Profile

empty

URL of Excel file

https://download.microsoft.com/download/5/b/d/5bd4a709-de6e-4586-883f-9701ab94e3e5/population.xlsx

Screenshots

Editor

...

Result

...

Helpful resources