How to use the URL to Excel file parameter in Excel for Confluence app

This article explains how to use the URL to Excel file parameter in the Excel for Confluence app.

Instructions

1. Log in as a Confluence administrator.
2. Navigate to  > Add-ons > Find new apps and search for "Excel for Confluence". Ensure you have Excel for Confluence app installed in your Confluence instance.
   
   
3. Log in as any user in your Confluence instance and add an Excel file to a page as required.
4. Right-click the file and select Copy Link Address. Note that this address is different from the URL of the webpage. 
   
5. Insert and Edit the Excel macro.
   
   

6. Enter the copied URL in the URL to Excel file field, and, provide the username and password in the URL user and URL user password fields respectively.

7. Save the macro settings and publish the page.

The output from the macro for the given example shows the data fetched from the URL as: