On this page
Features
- Displays Excel file(s) from an attachment, a URL or a profile
- Download Excel data from your page to your file system
- Select one or multiple worksheets
- Allows selection of any of the columns including the hidden ones
- Supports certain common table capabilities including sorting, auto numbering, auto total, and styling
- Enables conversion of spreadsheets to native tables
Displays many Excel formulas
If a cell value cannot be calculated due to an unknown formula, the cell displays #N/A in the resulting table. Only cell values with known calculation results are displayed in the table.
Basic use
This macro can be deployed using one of the following methods:
Selected from the Macro browser | Excel |
---|---|
Markup Shortcut | {excel} |
Parameters
Cloud specific parameters
Macro Editor Label | Default | Description | Macro Parameter |
---|---|---|---|
Output format | html | Specify how the output is treated. The options are as follows:
| output |
Page of attachment | Current page | Enter the location of data. The following locations are supported:
| page |
Name of attachment | Most recent Excel file uploaded to the current page | Enter the name of the attachment.
| name |
Profile | Enter a profile name. Administrators set up profiles to connect to remote locations to render Excel data across multiple pages. A profile usually contains the base URL and other credentials that are required to access a specific location. Enter the relative path to the actual location of the files in URL to Excel file to render files from the given location. Contact your administrator to know more about the profiles used in your instance. To know more about how profiles are configured, refer to this link. | profile | |
URL to Excel file | Enter the URL of the Excel file(s) to be displayed. If a valid path is entered here, the macro accesses the given location and processes the content accordingly. If Profile is specified, enter the relative path to the location of the Excel file(s). The file contents are then accessed and displayed through the macro. If an absolute URL is entered here, the macro reads content from the specified URL. If a profile is also specified, the macro ignores the given profile and processes content through the given URL. | url | |
URL user | Enter the user name for URL access through basic authentication. | user | |
URL user password | Enter the user password for URL access through basic authentication. | password | |
URL connection timeout | Enter time in milliseconds such that URL connections do not timeout before getting data. Use this to increase the access time needed for slow connections. Note that if a zero is given the connection may wait infinitely. | timeout | |
Sheets to import | Enter a comma separated list of sheet names to be shown. By default, each sheet in the workbook produces a table. The parameter value can be a comma separated list of sheet names (case sensitive) or sheet numbers (1-based counting). | sheets | |
Columns to show | Enter a comma separated list of column numbers. By default, all non-hidden columns are displayed in its existing order. Columns are enumerated starting at 1. If columns are specified, even hidden columns are shown. Rearrangement of columns, that is, column ordering is not supported (XL-63). | columns | |
Show hidden sheets, rows, and columns | false | Enable to show hidden elements of the worksheet. | showHidden |
Show sheet name before the table | false | Enable to display the worksheet name before the table. | showSheetName |
Use cell properties for formatting | false | Enable to process each cell for special properties. Currently, supported properties are:
| formatCell |
Show non-formatted version of generated wiki | false | Enable to show a non-formatted version of the wiki table following the formatted table. This is used to help resolve formatting issues. It can also be used to convert Excel to Confluence markup by cut and paste. | showWiki |
Escape special wiki characters | false | Enable to allow these special characters (like '|', '[', ']', '{', '}') to be escaped so that the table format remains unaffected. This option works when a wiki output is requested (Output format is wiki) as some special characters in data can cause incorrect table formatting. The default is false so that the data that has wiki markup can be handled correctly. | escape |
Include cell hyperlinks | true | Disable to display any hyperlinks in the data as normal text. By default, any hyperlinks in the data are retained as is. | hyperlinks |
When you provide all the parameters listed in the editor for the Excel file, the input provided using URL to Excel file takes precedence.
Common table parameters
Screenshot
Helpful resources
- Tutorials for examples on app usage