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:
- Login as an Confluence Administrator and
- Log in as a Confluence administrator.
- Navigate to > Add-ons > Find new apps and search for "Excel for Confluence". Ensure you have Excel for Confluence app installed in your confluence Confluence instance.
Go to the page and add a Excel file. - 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 below details:
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.- 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:
...