Excel for Confluence configuration - 6.x

Summary

This page (available since 6.8) provides instructions for configuring the Bob Swift Atlassian Excel for Confluence 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:

  1. Log in as a Confluence administrator with global permissions.
  2. Navigate to CONFLUENCE ADMINISTRATION > Cog menu () > Manage apps.
  3. Scroll down to BOB SWIFT CONFIGURATION on the left sidebar and select Excel to navigate to the Excel for Confluence Configuration page

This page contains global configuration settings that control the rendering of Excel content. Use the toggles to enable or disable the settings.

As an administrator, you can:

ParameterDescriptionDefault
Default 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:

  • Legacy: Provides backward compatibility for XLS files
  • Current: Processes Excel files with XLSX extension 

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.

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

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.

(Available since app version 6.8)

<empty>
Restrict URL accessSelect 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
Blacklist domains

Select this option to control whether or not certain domains are blacklisted. By default, this option is disabled for backward compatibility. (Available since app version 6.8)

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:

  • 10.0.0.0/8
  • 100.64.0.0/10
  • 127.0.0.0/8
  • 169.254.0.0/16
  • 172.16.0.0/12
  • 192.168.0.0/16
  • 192.0.0.0/24
  • 198.18.0.0/15
  • 255.255.255.255/32
  • 0.0.0.0/32
  • 192.0.2.0/24
  • 192.88.99.0/24
  • 198.51.100.0/24
  • 203.0.113.0/24
  • 224.0.0.0/4
  • 240.0.0.0/4
false
Help Us Improve the ProductEnable 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