Versions Compared

Key

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

This page provides instructions for configuring the Bob Swift Atlassian Excel for Confluence Cloud app. You can customize this app using various configuration options that are explained in the succeeding sections.

...

This page explains the various configuration settings that control the display of Excel content. Click any of the following links for more details:

Anchor
globalconfig
globalconfig
Global configuration

Use the toggles to enable or disable the settings.

Image RemovedImage Added

As an administrator, you can:

ParameterDefaultDescription
Maximum file size1

Enter the maximum size of the Excel file to be processed, in MBs. If a user tries to upload a file larger than the specified size, an error message is displayed.

Note

When the size is set to a value >1 MB, the user may encounter unexpected errors while uploading an Excel file.


Maximum row limit<empty>

Enter the maximum number of rows to be displayed from an Excel workbook. If defined, the specified number of rows are displayed from each worksheet in the workbook. Leave the field empty to display all rows.

Anchor
xl_cld_config_restrictURL
xl_cld_config_restrictURL
Restrict URL access
OffSelect this option to control whether or not URLs conform to the Confluence Whitelist, provided whitelisting is enabled. Confluence allows administrators to turn on whitelisting to restrict access to URLs configured in the Whitelist settingsEnable this option to restrict the macro to only those URLs listed in the allowlist.
Disable anti-xss modeOffEnable this option to globally turn off anti-XSS mode for all instances of the Excel macro. Administrators must ensure to take appropriate precautions as enabling this option can cause potential security risks. By default, the app respects Confluence's global Anti-XSS settings.
Help us improve the productOnEnable this option to report usage data that helps us improve the app continually. The app does not send any private user data or personally identifiable information. To learn more about what is being sent, refer to Analytics information.

...

Anchor
allowlist
allowlist
Allowlist

Manage the URLs that the app can access from this page. If the Restrict URL access option is enabled, the app is restricted to allow the specified URLs only.

Image RemovedImage Added

Parameter
Description
ExpressionEnter a URL or an expression here.
Type

Select a type from the following list:

  • Domain name - allows URLs of a specific domain. Example: https://www.example.com/.
  • Exact match - allows only the specified URL. Example: https://www.example.com/thispage.
  • Wildcard expression - allows all matching URLs. Use * as a wildcard character to replace one or more characters. Example: https://*example.com.
  • Regular expression - allows all URLs matching the specified regular expression. Refer to this link for more information about regular expressions. Example: http(s)?://www\.example\.com. 

You can perform the following actions on this page:

  • Add the URL after specifying the Expression and Type.
  • Update after modifying the details. Select the Expression to enable editing of the URL.
  • Delete to remove the URL.
  • Save after adding or modifying any URL in the list.

Anchor
profiles
profiles
Profiles

Profiles consist of a set of basic parameters that allow users to access content from external sources in the macros. With profiles, you can:

  • Allow user authentication required by some URLs to be hidden from page viewers and editors. Confluence administrators can access this information.
  • Reuse a shared definition for URL access; thus, enable quick macro configurations. 
  • Provide base URLs to make fewer changes to page content if these URLs are relocated. 
    • Macro configured URL (not a full URL but a relative path) is appended to the profile provided URL to access the actual location of the files.

Image RemovedImage Added

The page displays a list of profiles available for the macros. Click Add Profile to open a pop-up window as:

Image RemovedImage Added

Parameter
Description
Profile nameEnter a name for the profile.
Profile typeDisplays URL as selected, by default. 
URLEnter the URL to be accessed.
User; PasswordEnter the user name and password to access the specified URL.
Access tokenEnter the access token to access the specified URL, if needed. Administrators must generate the access tokens from applications, if required, and enter that here.
URL parametersMention any extra parameters that must be appended to the URL here. 
Request headersDisplays the request header(s) created as per the given information.

You can perform the following actions on this page:

...