Summary
This page (available since 6.8) 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.
Global configuration
After upgrading or installing Excel for Confluence, follow the steps mentioned below to navigate to the Global configuration:
- Log in as a Confluence administrator with global permissions.
- Click Settings icon Navigate to CONFLUENCE ADMINISTRATION > Cog menu (
) , scroll down to ATLASSIAN MARKETPLACE on > Manage apps.
- Scroll down to BOB SWIFT CONFIGURATION on the left sidebar , and select Excel Configuration Excel to navigate to open the Excel for Confluence Configuration page.
This page explains the various contains global configuration settings that control the rendering of Excel content. Click any of the following sections for more details:
Global configuration
Use Use the toggles to enable or disable the settings.
<screenshot>
As an administrator, you can:
- 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.
Profiles
Profiles consist of a common set of parameters that allow users to choose a profile in the macros. Some advantages of using profiles are:
- Profiles allow user authentication required by some URLs to be hidden from page viewers and editors. Only Confluence administrators have access to this information.
- Enables macro editors to quickly configure the macro by reusing a shared definition for URL access.
- Relative addressing can be used making the page content less likely to require changes when base URLs are relocated.
- Macro configured URL (that is not a full URL) is appended to the profile provided URL.
<screenshot>
The page displays a list of profiles available for the macros. Click Add Profile to open a pop-up window as:
<screenshot>
...
...
...
You can perform the following actions on this page:
...
| Parameter | Description | Default | ||||
|---|---|---|---|---|---|---|
| Default | Maximum file process option | Select an option to control the method used to process Excel files through the macro. However, depending on the way the macro is used, this setting can be overridden. The following options are available:
Both options process the xlsx files in the same way, with the difference being in how xls files is handled. | Legacy | |||
| Maximum xslx file size | 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.
| 1 | ||||
| Maximum row limit | 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. | <empty> | ||||
| Anchor | xl_cld_config_restrictURL | xl_cld_config_restrictURL(Available since app version 6.8) | <empty> | |||
| Restrict URL access | Select 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 settings. | false | ||||
| Help us improve the product | Enable 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. | true |
Whitelist
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.
<screenshot>
...
...
...
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:
| Blacklist domains | Select this option to control whether or not certain domains are blacklisted. By default, this option is disabled for backward compatibility. If enabled, and if a request from any of these sites is received, an error message is displayed. However, if users still need to access a blacklisted site, they must contact their administrator to disable this option. Click the link named listed (in the description beneath the option) to view a pre-defined list of the most commonly blacklisted domains in a pop-up window. The following sites are blacklisted, by default:
(Available since app version 6.8) | false |
| Help Us Improve the Product | Enable 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. | true |