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. Login as an Confluence Administrator and 
  2. Log in as a Confluence administrator.
  3. Navigate to Image Added > Add-ons > Find new apps and search for "Excel for Confluence". Ensure you have Excel for Confluence app installed in your confluence Confluence instance.
    Image Removed
    Go to the page and add a Excel file. Image Added
  4. Log in as any user in your Confluence instance and add an Excel file to a page as required.
  5. 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
  6. Insert and Edit the Excel macro.
    Image RemovedImage Added
  7. Enter the below details:Image Removed
    Image Removedcopied URL in the URL to Excel file field, and, provide the username and password in the URL user and URL user password fields respectively.Image Added

  8. 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