Confluence Repository Client
or upload from Confluence's administration console. Cannot be installed in /WEB-INF/lib
Description
Generate Confluence tables from Excel worksheets. Support is based on JExcelApi which supports data from Excel 95, 97, 2000, XP, and 2003 workbooks. Excel 2007 .xlsx format is not currently supported.
The url parameter is restricted to trusted user by configuring security using the Macro Security Plugin.
Security migration from 3.4.0 and earlier
Macro security users upgrading to 3.5.0 or above from 3.4.0 or earlier must install and config the Macro Security Plugin to retain your security setting for the url parameter.
file - Location of excel file. Either file or url is required.
^attachment - Data is read from an attachment to the current page.
page^attachment - Data is read from an attachment to the page name provided.
space:page^attachment - Data is read from an attachment to the page name provided in the space indicated.
filename - Data is read from the file located in /script/filename. Subdirectories can be specified.
url - Only required if file is not specified. Specifies the URL of an Excel file.
Use of this parameter may be restricted for security reasons. See your administrator for details. See Macro Security Plugin.
sheets - By default, each sheet in the workbook will produce a table. Use the sheets parameter to control what sheets will be shown. The parameter value can be a comma separated list of sheet names (case sensitive) or sheet numbers (1-based counting)
columns - A comma separated list of column numbers used to select and order columns to be shown. If columns is specified, even hidden columns will be shown.
output - Determines how the output is formated:
html - Data is output as a HTML table (default).
wiki - Data is output as a Confluence wiki table. Use this option if you want data within the table to be formated by the Confluence wiki renderer.
heading - Number of rows to be considered heading rows (default is 1 row). Specify heading=false or heading=0 to not show any heading lines.
border - The border width in pixels. Defaults to normal table border width.
width - The table width in pixels. Default is 100%.
showHidden - By default, hidden sheets, rows, and columns will not be shown. Set showHidden=true to show all data.
showSheetName - By default, the sheet name will not be shown. Set showSheetName=true to show a the sheet name before the table.
formatCell - By default, no special formating will be applied to the cells. Set formatCell=true 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 - By default, the format for a column will be used to apply formating for all cells in the column. Set formatColumn=false to not use the column formating information from the excel sheet. Note that this parameter is ignored if formatCell=true or columnAttributes are specified.
showWiki - Default is false. Set to true to show a non-formatted version of the wiki table following the formatted table. This is used to help resolve formating issues. It can also be used to convert an Excel spreadsheet to Confluence markup by cut and paste. Excel to Confluence Converter is an alternative way to do this.
escape - The '|' character in data can cause formatting of the table to be incorrect because it is interpreted as a column boundary. Set escape=true to allow this character to be escaped so that it will not affect the formatting. The default is false so that things like wiki links are handled correctly.
hyperlinks - Default is true. Set to false to disable inclusion of cell hyperlinks.
ignoreTrailingBlankRows - By default, all trailing blank rows will be ignored. Set ignoreTrailingBlankRows=false to show these blank rows.
ignoreTrailingBlankColumns - By default, all trailing blank columns will be ignored. Set ignoreTrailingBlankColumns=false to show these blank columns.
language - If provided, the language and country specification will be used to provide number and date formats to be used for data conversion. This specification will be used before the default languages automatically used. Valid values are 2 character ISO 639-1 alpha-2 codes.
country - Used in combination with the language parameter. Valid values are 2 character ISO 3166 codes.
Usage
Simple attachment
{excel:file=^Report.xls}
Sheet selection
{excel:file=Year 2005^Report.xls|sheet=First Quarter, Second Quarter}
Accessing a file in confluence home directory .../script/excel files
Cannot be installed in /WEB-INF/lib 
3.5.0
(#8)
Open
Resolved
Closed
Comments (191)
Dec 26, 2005
Jonathan Nolen says:
Dude, this rocks! So many people are going to love this. Thanks!Dude, this rocks! So many people are going to love this. Thanks!
Dec 27, 2005
Martin Ollesch says:
Very great and useful macro! Thank You! Btw, linebreaks in Excel cells are lost...Very great and useful macro! Thank You!
Btw, linebreaks in Excel cells are lost if output is html and not wiki.