Removed the URL user and URL user password parameters

This page describes the parameters removed, changes, and how the app handles these changes in Excel for Confluence - Server and Cloud version.

Parameters removed

The URL user and URL user password parameters are removed from Excel for Confluence and are no longer available in the Excel macro.

Parameter removal is effective and available in:

  • Excel for Confluence - Server (version 7.3.0 and above)

  • Excel for Confluence - Cloud

Excel for Confluence app updates

The Excel for Confluence app now uses only Profile for the new macro configurations. You can use a Profile to access Excel data from a remote location without exposing any sensitive information.

  • Upgrade the app and use Profile to access the Excel data from external sources without exposing sensitive information such as a password.

  • The macro editor does not display the URL user and URL user password parameters.

  • Pre-configured macros using the URL user and URL user password parameters are supported. The Confluence page retains the values of the URL user and URL user password parameters in the Storage Format.

Follow the steps given below to create a Profile and configure the Excel macro using the Profile.

Create a Profile to access the external sources

Administrators create a Profile by defining a set of parameters, such as the base URL of the location for the Excel data, User, Password, and other relevant information to access the specified location. For more information, refer to Create a profile with a URL.

Use Profile to access the Excel data

To configure the Excel macro to use Profile:

  1. Select the Profile from the Profile drop-down.

  2. Enter the relative URL in the URL to Excel file parameter.

For more information, refer to:

How the change impacts the pre-configured macro?

The removal of parameters does not impact the existing macro configurations or pre-configured macros. Below are the various configuration changes to help you consider and plan the Excel macro configuration.

Retain the pre-configured Excel macro

  • Retain the pre-configured Excel macro with the URL user and URL user password parameters without any change.

  • Though the macro editor does not display the parameters, the Confluence page still retains the values of the URL user and URL user password parameters. The app fetches the parameter values from the Storage Format to retrieve the data from the remote location.

Modify the pre-configured Excel macro parameter values

Modify any of the parameter values such as Page for attachment, Name of attachment, Name of attachment in the path, Profile, or URL to Excel file in the pre-configured macro. The app considers the updated value of the parameters to fetch the data.

If the macro configuration contains Profile:

  • The macro considers the values of the parameters, User, and Password from the Profile for authentication. The app fetches the data based on the chosen Profile and relative URL provided in the URL to Excel file.

If the macro configuration does not contain Profile:

  • The macro considers the values of the parameters, URL user, and URL user password from the Storage Format for authentication. The app fetches the data based on the URL provided in the URL to Excel file.

Excel macro - Server

 

Excel macro - Cloud

 

Copy the pre-configured Excel macro

The behavior of the newly copied macro remains the same as the original pre-configured macro.

You can:

  • copy the pre-configured macro on the same or another Confluence page.

  • copy the page containing the pre-configured Excel macro in the same space or another space.

References