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}

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.

The following parameters are part of our common table capabilities that are available to many macros that produce or modify tables.

Click a column heading to toggle the sorting of that column.

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