| Div |
|---|
|
On this page| Table of Contents |
|---|
| maxLevel | 1 |
|---|
| exclude | On this page |
|---|
| type | flat |
|---|
| separator | pipe |
|---|
|
|
Overview
| Excerpt |
|---|
The Excel macro displays displays one or more Excel worksheets on a Confluence page. The following features are included: |
Basic
...
use
This macro can be deployed using one of the following methods:
| Selected from the Macro Browser | Excel |
|---|
| Markup Shortcut | {excel} |
|---|
Screenshot
Parameters
| Table plus |
|---|
| highlightColor | #ffffec |
|---|
| rowStyles | background:#f0f0f0;color:#222;font-size:14px;border-bottom:black 2px solid;border-top:black 2px solid;, |
|---|
| multiple | false |
|---|
| style | background-color:white; |
|---|
| autoNumber | true |
|---|
|
| | | |
|---|
| output | html | Output format | Determines how the output is formatted. Use wiki to have the data in the table rendered by the wiki renderer. | | page | Current page | Page for attachment | Specifies the page for attachment from the same space or different space. Since 6.6.0. | | name | Latest Excel file in the Current page | Name of attachment | Allows you to select the name of the attachment from the available list. Since 6.6.0. | | filename |
| Name of attachment in the path | Specify the name of the attachment in confluence home/script directory. Since 6.6.0. | | url |
| URL to Excel file | Specifies the URL of an Excel file. Use of this parameter may be restricted for security reasons. See your administrator for details. | | user |
| URL user | Username for URL access via basic authentication. | | password |
| URL user password | User password for URL access via basic authentication. | | timeout |
| URL connection timeout | Allows setting the wait time for URL access for slower connections. Time in milliseconds. | | encoding |
| File encoding | File encoding for an external file if different from the system default handling. Since 4.1.0. Example: UTF-8. More ... | | language |
| Language for number and date formats | If providedspecified, the language and country specification will be is used to provide number and date formats to be used for data conversion. This specification will be is used before the default languages automatically used. Valid values are 2 character character ISO 639-1 alpha-2 codes. | | country |
| Country | Used in combination with the language parameter. Valid values are 2 character ISO 3166 codes. | | sheets |
| Sheets to import | By default, each sheet in the workbook will produce produces a table. Use the sheets parameter to control what sheets will are to be shown. The parameter value can be a comma-separated list of sheet names (case sensitive) or sheet numbers (1-based counting). | | columns |
| Columns to show | Comma-separated list of column numbers. Defaults to all non-hidden columns in existing order. Columns are enumerated starting at 1. If columns are specified, even hidden columns will be are shown. Column ordering is not supported (XL-63). | | showHidden | false | Show hidden sheets, rows, columns | Use true Enable to show hidden elements. | | showSheetName | false | Show sheet name before the table |
| | formatCell | false | Use cell properties for formatting | Use true Enable to process each cell for special properties. Currently, supported properties are:- html - Alignment, font, and background color.
- wiki - None at this time for individual cells. For columns, formatColumn can be used. Another alternative is to use columnAttributes from from Common Table Capabilities.
| | formatColumn | true | Use column information from excel Excel sheet | Disable to not use the column formatting information from the Excel sheet. By default, the format for a column will be is used to apply formatting for all cells in the column. Use false to not use the column formatting information from the excel sheet. Note that this parameter is ignored if formatCell=true or columnAttributes are specified. | | hyperLinks | true | Include cell hyperlinks |
| | ignoreTrailingBlankRows | true | Ignore trailing blank rows | Disable to show these blank rows. A row is considered blank if all the columns selected by the column parameter are blank. Use false to show these blank rowsfor all columns are blank. | | ignoreTrailingBlankColumns | true | Ignore trailing blank columns |
| | showWiki | false | Show non-formatted version of the generated wiki | Use true 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 Confluence markup by cut and paste. | | escape | false | Escape special wiki characters | When wiki Enable to allow special characters to be escaped so that formatting is not affected. This is in case wiki output is requested (output=wiki) , and some special characters (like '|', '[', ']', '{', '}') in data may cause undesirable formatting of the table. Use true to allow these special characters to be escaped so that it will not affect the formatting. The default is false so that data that has wiki markup will be is handled correctly. |
|
| Note |
|---|
When you provide all the parameters listed in the editor window for the Excel file, the input provided using URL to Excel file takes precedence. |
Common
...
table parameters
| Include Page |
|---|
| info:_CommonTableCapabilitiesParameters |
|---|
| info:_CommonTableCapabilitiesParameters |
|---|
|
Compatibility
...
with other macros
- Chart - this macro can be used to supply data for a chart
- GVIZ - this macro can be used to supply data for the Graph from table macro