Versions Compared

Key

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

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:

  1. Log in as a Confluence Administrator and administrator.
  2. Navigate to Image Modified >   Add-ons  →  Find new apps and  and search for "Excel for Confluence". Ensure you have Excel for Confluence app installed in your Confluence instance.
    Image Modified
  3. With Log in as any user log in to the confluence, go to the page in your Confluence instance and add an Excel file to a page as required.
  4. Right-click on the file and select Copy Link Address. Note that this address is different from the URL of the webpage. 
    Image RemovedImage Added
  5. Insert and Edit the Excel macro.
    Image RemovedImage Added
  6. Enter the copied URL in the field "URL to Excel file" and provide the "URL user" and "URL user password" in the respective fields as shown below:Image Removed
    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. Below is the

The output from the macro

...

for the given example shows the data fetched from the URL as:

...

Image Added