This article explains how to access use the parameter "URL to Excel file" parameter in the app the Excel for Confluence app.
Instructions
Here are the instructions to access the excel file from the specified URL:
- Log in as a Confluence Administrator and administrator.
- Navigate to > Add-ons → > Find new apps and and search for "Excel for Confluence". Ensure you have Excel for Confluence app installed in your Confluence instance.
Go to the page - Log in as any user in your Confluence instance and add an Excel file to a page as required.
- Right-click on the file and select Copy Link Address. Note that this address is different from the URL of the webpage.
- Insert and Edit the Excel macro.
Enter the copied URL in the field "URL to Excel file" and file field, and, provide the username and password as shown below:
in the URL user and URL user password fields respectively.- Save the macro settings and publish the page. Below is the
The output from the macro
...
for the given example shows the data fetched from the URL as:
...