---
title: "Excel macro - cloud"
canonical: "https://support.appfire.com/space/XL/76612167/Excel%20macro%20-%20cloud"
format: markdown
---
> Macro (aura-html)

# Features

- <span style="color: #000000">Convert your Excel spreadsheets into tables</span>
- <span style="color: #000000">Access data from Excel files from attachments on any Confluence page, URLs or pre-configured profiles</span>
- <span style="color: #000000">Download Excel table data as a CSV file</span>
- <span style="color: #000000">Display and format</span><span style="color: #000000"> one or more worksheets in your Excel files</span>
- <span style="color: #000000">Format any of the columns, including the hidden ones, with your own styles</span>
- <span style="color: #000000">Work with</span><span style="color: #000000"> </span><span style="color: #000000">[common table capabilities](https://appfire.atlassian.net/wiki/spaces/XL/pages/76612167/Excel+macro+-+cloud#Excelmacro-cloud-XLCLD_commontableparameters)</span><span style="color: #000000"> including sorting, column totals, and row numbering</span>
- <span style="color: #000000">Displays results of most Excel formulas </span>

> ℹ️ If 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

<span style="color: #000000">This macro can be deployed using one of the following methods:</span>

| <span style="color: #000000">**Selected from the Macro browser**</span> | <span style="color: #000000">Excel</span> |
| --- | --- |
| **Markup Shortcut (New editor - case insensitive)** | /Excel |

![Excel macro configuration_Editor](media://990dce2a-cf6f-45da-9023-4b8b9123debe)

# <span style="color: #000000">Parameters</span>

> ⚠️ **Parameters removed**
> ⚠️ 
> ⚠️ - <span style="color: #000000">The </span><span style="color: #000000">*URL user*</span><span style="color: #000000"> and </span><span style="color: #000000">*URL user password*</span><span style="color: #000000"> parameters have been removed from </span><span style="color: #000000">*Excel for Confluence*</span><span style="color: #000000">. For more information, refer to</span><span style="color: #800000"> </span><span style="color: #000000">[Removed the URL user and URL user password parameters](https://appfire.atlassian.net/wiki/spaces/XL/pages/76614287)</span><span style="color: #000000">.</span>
> ⚠️ - <span style="color: #000000">Use</span><span style="color: #800000"> </span><span style="color: #000000">[Profile](https://appfire.atlassian.net/wiki/spaces/XL/pages/76611721/Configuration+-+cloud#profiles)</span><span style="color: #800000"> </span><span style="color: #000000">to access Excel data from a remote location.</span>

## <span style="color: #000000">Macro specific </span><span style="color: #000000">parameters</span>

| <span style="color: #000000">**Macro Editor Label**</span> | <span style="color: #000000">**Default**</span> | <span style="color: #000000">**Description**</span> | <span style="color: #000000">**Macro Parameter**</span> |
| --- | --- | --- | --- |
| <span style="color: #000000">Output format</span> | <span style="color: #000000">*html*</span> | <span style="color: #000000">Specify how the </span><span style="color: #000000">output is displayed</span><span style="color: #000000">. The options are as follows:</span><br>- <span style="color: #000000">*html*</span><span style="color: #000000"> - data is rendered as an HTML table</span>
- <span style="color: #000000">*wiki*</span><span style="color: #000000"> - data is rendered in a table with wiki markup</span>
- <span style="color: #000000">*unrenderedWiki*</span><span style="color: #000000"> - data is rendered as text with wiki markup</span> | <span style="color: #000000">output</span> |
| <span style="color: #000000">Page for attachment</span> | <span style="color: #000000">Current page</span> | <span style="color: #000000">Enter the location where the Excel files are available.</span><span style="color: #000000"> The following locations are supported:</span><br>- <span style="color: #000000">*page*</span><span style="color: #000000"> - </span><span style="color: #000000">Data is read from an attachment to the page specified here; provided that </span><span style="color: #000000">*page*</span><span style="color: #000000"> is in the same space as the page with the macro.</span>
- <span style="color: #000000">*space:page*</span><span style="color: #000000"> - </span><span style="color: #000000">Data is read from an attachment to the specified </span><span style="color: #000000">*page*</span><span style="color: #000000"> that is in the specified </span><span style="color: #000000">*space*</span><span style="color: #000000">.</span> | <span style="color: #000000">page</span> |
| <span style="color: #000000">Name of attachment</span> | <span style="color: #000000">Most recent Excel file uploaded to the current page</span> | <span style="color: #000000">Enter the name of the attachment. </span><br>> ⚠️ - <span style="color: #000000">If the </span><span style="color: #000000">*Page for attachment*</span><span style="color: #000000"> is empty, the attachment specified here is considered to be on the current page.</span>
> ⚠️ - <span style="color: #000000">If this field is left empty and if </span>*Profile*<span style="color: #000000"> or </span>*URL to Excel file*<span style="color: #000000"> are not specified, the macro renders data from the most recent Excel file that was uploaded to the current page. </span> | <span style="color: #000000">name</span> |
| <span style="color: #000000">Profile</span> |  | <span style="color: #000000">Enter a profile name.</span><span style="color: #000000"> Contact your administrator to know which profiles are available for use in your instance.</span><br><span style="color: #000000">Administrators set up profiles to connect to </span><span style="color: #000000">external sources </span><span style="color: #000000">to render Excel data across multiple pages so that sensitive information like passwords and access tokens can be secured and hidden from view. A profile usually contains the base URL and other credentials that are required to access a specific location. </span><br><span style="color: #000000">Enter the relative path to the actual location of the Excel files in the field, </span><span style="color: #000000">*URL to Excel file*</span><span style="color: #000000">. </span><br>> ℹ️ <span style="color: #000000">To know more about how profiles are configured, refer to </span><span style="color: #000000">[this page](https://appfire.atlassian.net/wiki/spaces/XL/pages/76611721/Configuration+-+cloud#profiles)</span><span style="color: #000000">.</span> | <span style="color: #000000">profile</span> |
| <span style="color: #000000">URL to Excel file</span> |  | <span style="color: #000000">Enter the URL of the Excel file(s) to be displayed. If you enter a valid path, the macro accesses the given location and renders the content from the specified </span><span style="color: #000000">*Profile*</span><span style="color: #000000"> and </span><span style="color: #000000">*URL*</span><span style="color: #000000">.</span><br>- <span style="color: #000000">Use a </span><span style="color: #000000">*Profile*</span><span style="color: #000000"> configured with an absolute URL and valid </span><span style="color: #000000">*User*</span><span style="color: #000000"> and </span><span style="color: #000000">*Password *</span><span style="color: #000000">to access the Excel data from private sources. The macro reads the content from the specified URL in the profile. </span>
- <span style="color: #000000">Use a </span><span style="color: #000000">*Profile*</span><span style="color: #000000"> configured with an absolute URL to access the Excel data from public sources, or provide the publicly hosted absolute URL in the </span><span style="color: #000000">*URL to Excel*</span><span style="color: #000000"> </span><span style="color: #000000">*file*</span><span style="color: #000000"> field. Authentication is not required to access the Excel data from public sources, and the macro reads the content from the specified URL. </span>
- <span style="color: #000000">Use a </span><span style="color: #000000">*Profile*</span><span style="color: #000000"> configured with a base URL and valid </span><span style="color: #000000">*User*</span><span style="color: #000000"> and </span><span style="color: #000000">*Password.*</span><span style="color: #000000"> Enter the relative path to the actual location of the Excel file(s) in the field </span><span style="color: #000000">*URL to Excel file*</span><span style="color: #000000"> field. The macro appends the URL given here with the URL specified in the profile configuration to access the location and render the required Excel data.</span><br>> ⚠️ <span style="color: #000000">It is recommended to use </span><span style="color: #000000">*Profile*</span><span style="color: #000000"> and provide the relative path to the actual location of the Excel file(s) in the field, </span><span style="color: #000000">*URL to Excel file*</span><span style="color: #000000">.</span> | <span style="color: #000000">url</span> |
| <span style="color: #000000">URL connection timeout</span> |  | <span style="color: #000000">Enter time in milliseconds such that URL connections do not timeout before getting data. Use this to increase the access time needed for slow connections. Note that if a zero is given, the connection may wait infinitely.</span> | <span style="color: #000000">timeout</span> |
| <span style="color: #000000">Sheets to import</span> |  | <span style="color: #000000">Enter a comma separated list</span><span style="color: #000000"> of sheet names to be shown in the order specified here. By default, each sheet in the workbook produces a table. The parameter value can be a comma separated list of sheet names (case sensitive) or sheet numbers (1-based counting).</span> | <span style="color: #000000">sheets</span> |
| <span style="color: #000000">Columns to show</span> |  | <span style="color: #000000">Enter a comma separated list of column numbers in the order specified here. By default, all non-hidden columns are displayed in its existing order. Columns are enumerated starting at 1. If columns are specified, even hidden columns are shown. </span><br>> ⚠️ <span style="color: #000000">Rearrangement of columns, that is, column ordering is not supported. (</span>[XL-63](https://studio.plugins.atlassian.com/browse/XL-63)<span style="color: #000000">)</span> | <span style="color: #000000">columns</span> |
| <span style="color: #000000">Show hidden sheets, rows, and columns</span> | <span style="color: #000000">false</span> | <span style="color: #000000">Enable</span><span style="color: #000000"> this option to show hidden elements of the worksheet.</span> | <span style="color: #000000">showHidden</span> |
| <span style="color: #000000">Show sheet name before the table</span> | <span style="color: #000000">false</span> | <span style="color: #000000">Enable this option to display the worksheet name before the table.</span> | <span style="color: #000000">showSheetName</span> |
| <span style="color: #000000">Use cell properties for formatting</span> | <span style="color: #000000">false</span> | <span style="color: #000000">Enable this option to process each cell for special properties. Currently, supported properties are:</span><br>- <span style="color: #000000">*html*</span><span style="color: #000000"> - Alignment, font, and background color.</span>
- <span style="color: #000000">*wiki*</span><span style="color: #000000"> - None at this time for individual cells. For columns, the</span><span style="color: #000000">* Use column information from Excel sheet*</span><span style="color: #000000"> parameter can be used. Another alternative is to use </span><span style="color: #000000">*Column attributes*</span><span style="color: #000000"> from</span> [common table parameters](https://appfire.atlassian.net/wiki/spaces/XL/pages/76612167/Excel+macro+-+cloud#Excelmacro-cloud-XLCLD_commontableparameters)<span style="color: #000000">.</span> | <span style="color: #000000">formatCell</span> |
| <span style="color: #000000">Show non-formatted version of generated wiki</span> | <span style="color: #000000">false</span> | <span style="color: #000000">Enable this option 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 </span><span style="color: #000000">*Excel to Confluenc*</span><span style="color: #000000">e markup by cut and paste.</span> | <span style="color: #000000">showWiki</span> |
| <span style="color: #000000">Escape special wiki characters</span> | <span style="color: #000000">false</span> | <span style="color: #000000">Enable this option to allow these special characters (like '</span><span style="color: #000000">**|**</span><span style="color: #000000">', '</span><span style="color: #000000">**[**</span><span style="color: #000000">', '</span><span style="color: #000000">**]**</span><span style="color: #000000">', '</span><span style="color: #000000">**{**</span><span style="color: #000000">', '</span><span style="color: #000000">**}**</span><span style="color: #000000">') to be escaped so that the table format remains unaffected. This option works when a wiki output is requested (</span><span style="color: #000000">*Output format*</span><span style="color: #000000"> is </span><span style="color: #000000">*wiki*</span><span style="color: #000000">) as some special characters in data can cause incorrect table formatting. The default is false so that the data that has wiki markup can be handled correctly.</span> | <span style="color: #000000">escape</span> |
| <span style="color: #000000">Include cell hyperlinks</span> | <span style="color: #000000">true</span> | <span style="color: #000000">Disable this option to display any hyperlinks in the data as normal text. By default, any hyperlinks in the data are retained as is.</span> | <span style="color: #000000">hyperlinks</span> |

> ⚠️ <span style="color: #000000">When you provide all the parameters listed in the editor for the Excel file, the input provided using </span>*URL to Excel file*<span style="color: #000000"> takes precedence.</span>

## > Macro (anchor)

Common table parameters

> Macro (include)

## Helpful resources

- [Use cases](https://appfire.atlassian.net/wiki/spaces/XL/pages/76611727) for examples on app usage