On this page
Overview
The Excel macro displays one or more Excel worksheets on a Confluence page. The following features are included:
Supports many Excel formats:
xls format from Excel 95, 97, 2000, XP, and 2003 workbooks
xlsx format from Excel 2007 and later (available starting with Release 5.0)
Flexible location of the Excel file
- Attachment
- URL
- File system of Confluence server
- Compatible with the Chart macro to create charts
- Sheet selection - one or more or all
- Column selection - any of the columns including hidden columns
- Supports Common table capabilities including sorting, auto numbering, auto total, and styling
- Enables conversion of spreadsheets to native tables
- Enabled for Macro Security for Confluence to allow control of url and profile parameters. See Macro Security Managed Macros.
- Supports most Excel formulas - when 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} |
Screenshot
Parameters
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
Compatibility with other macros
- Chart - this macro can be used to supply data for a chart
- Graphviz Diagrams for Confluence - this macro can be used to supply data for the Graph from table macro