How to render data from Excel files with URLs

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

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

How to create a profile with URLs
Profiles in the app's configuration settings