Versions Compared

Key

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

...

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 How to create Create a profile with URLsa URL.

...

Use Profile to access the Excel 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.

Image RemovedImage Added

Anchor
anchor3
anchor3
Copy the pre-configured Excel macro

...