| | | |
---|
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. |
name | Latest Excel file in the Current page | Name of attachment | Allows you to select the name of the attachment from the available list. |
filename |
| Name of attachment in the path | Specify the name of the attachment in confluence home/script directory. |
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. Example: UTF-8. More ... |
language |
| Language for number and date formats | If specified, the language and country specification is used to provide number and date formats to be used for data conversion. This specification is used before the default languages automatically used. Valid values are 2 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 produces a table. Use the sheets parameter to control what sheets 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 are shown. Column ordering is not supported (XL-63). |
showHidden | false | Show hidden sheets, rows, columns | Enable to show hidden elements. |
showSheetName | false | Show sheet name before the table |
|
formatCell | false | Use cell properties for formatting | 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 Common Table Capabilities.
|
formatColumn | true | Use column information from Excel sheet | Disable to not use the column formatting information from the Excel sheet. By default, the format for a column is used to apply formatting for all cells in the column. 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 the column parameter for all columns are blank. |
ignoreTrailingBlankColumns | true | Ignore trailing blank columns |
|
showWiki | false | Show non-formatted version of the generated wiki | 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. |
escape | false | Escape special wiki characters | 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. The default is false so that data that has wiki markup is handled correctly. |