---
title: "FAQs for the Excel for Confluence app"
canonical: "https://support.appfire.com/space/SUPPORT/89134202/FAQs%20for%20the%20Excel%20for%20Confluence%20app"
format: markdown
---
## <span style="color: #000000">Overview</span>

> Macro (excerpt)
> 
> <span style="color: #000000">This page presents the answers to the most frequently asked questions about the </span>*<span style="color: #000000">Excel for Confluence</span>*<span style="color: #000000"> app.</span>

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

<details>
<summary>How can I export or download an Excel file using this app?</summary>

<span style="color: #000000">Yes, we can download an Excel file using this app.</span>

<span style="color: #000000">Edit the </span>*<span style="color: #000000">Excel for Confluence</span>*<span style="color: #000000"> </span><span style="color: #000000">macro</span><span style="color: #000000">, check the </span>*<span style="color: #000000">Allow download and export</span>*<span style="color: #000000"> </span><span style="color: #000000">option </span><span style="color: #000000">and click </span><span style="color: #000000">**Save.  **</span>  
> Macro (inline-media-image)
</details>

<details>
<summary>How to display data from an Excel file?</summary>

<span style="color: #000000">Edit the </span>*<span style="color: #000000">Excel for</span>*<span style="color: #000000"> Confluence macro</span>*<span style="color: #000000">,</span>*<span style="color: #000000"> enter the </span>*<span style="color: #000000">Name of</span>*<span style="color: #000000"> </span>*<span style="color: #000000">attachment</span>*<span style="color: #000000">, and, click </span><span style="color: #000000">**Save.  **</span>  
> Macro (inline-media-image)
</details>

<details>
<summary>How to read data from an Excel attachment that is in another space?</summary>

<span style="color: #000000">To read from an Excel attachment that is in another space, e</span><span style="color: #000000">dit the </span>*<span style="color: #000000">Excel for Confluence</span>*<span style="color: #000000"> </span><span style="color: #000000">macro </span><span style="color: #000000">in the relevant page</span>*<span style="color: #000000">.</span>*

1. <span style="color: #000000">Enter the </span>**<span style="color: #000000">SPACEKEY:Page title </span>**<span style="color: #000000">in </span>*<span style="color: #000000">Page for attachment</span>**<span style="color: #000000">. </span>*<span style="color: #000000">The value entered here must be that of the space key and title of the page that the app must access.</span>
2. <span style="color: #000000">Select the required Excel file from the list in</span>*<span style="color: #000000"> Name of attachment</span>*<span style="color: #000000"> and click </span><span style="color: #000000">**Save.**</span>  
> Macro (inline-media-image)
</details>

<details>
<summary>How can I select or display the sheet name from the workbook?</summary>

<span style="color: #000000">In </span>*<span style="color: #000000">Edit 'Excel' Macro</span>*<span style="color: #000000"> screen</span>**<span style="color: #000000">, </span>**<span style="color: #000000">scroll down to select the </span>*<span style="color: #000000">Show sheet name before the table</span>*<span style="color: #000000"> </span><span style="color: #000000">option, and</span><span style="color: #000000"> click </span>**<span style="color: #000000">Save</span>**<span style="color: #000000">. </span>

<span style="color: #000000">In the following screenshot, "Project" and "Issues" are the names of worksheets in the specified workbook:</span>  
> Macro (inline-media-image)
</details>

<details>
<summary>Is there an option to sort column data that is read from an Excel file?</summary>

<span style="color: #000000">Yes, use the </span>*<span style="color: #000000">Show sort icon</span>*<span style="color: #000000"> option to make column data sortable.</span>

<span style="color: #000000">In the </span>*<span style="color: #000000">Edit 'excel' Macro</span>*<span style="color: #000000"> screen</span>**<span style="color: #000000">, </span>**<span style="color: #000000">select the </span>*<span style="color: #000000">Show sort icon </span>*<span style="color: #000000">option and</span><span style="color: #000000"> click </span>**<span style="color: #000000">Save</span>**<span style="color: #000000">.</span>  
> Macro (inline-media-image)
</details>

<details>
<summary>How to calculate the sum of numeric data that is read from an Excel file?</summary>

<span style="color: #000000">In the </span>*<span style="color: #000000">Edit 'excel' Macro</span>*<span style="color: #000000"> screen:</span>

1. <span style="color: #000000">Enter a comma separated list in </span>*<span style="color: #000000">Column types</span>*<span style="color: #000000">. Refer to</span><span style="color: #333333"> </span>[<span style="color: #333333">this document</span>](https://appfire.atlassian.net/wiki/spaces/XL/pages/76614039/Excel+Macro)<span style="color: #333333"> </span><span style="color: #000000">for more information about field and various type indicators.</span>  
> Macro (inline-media-image)
2. <span style="color: #000000">Select the </span>*<span style="color: #000000">Auto total row</span>*<span style="color: #000000"> option and click </span>**<span style="color: #000000">Save</span>**<span style="color: #000000">.</span>  
> Macro (inline-media-image)
</details>

<details>
<summary>Can I display only selected column(s) from the Excel sheet?</summary>

<span style="color: #000000">Yes, the </span>*<span style="color: #000000">Excel</span>*<span style="color: #000000"> macro has an option to display the selected column(s) from the Excel sheet.</span>

<span style="color: #000000">In </span>*<span style="color: #000000">Edit 'excel' Macro</span>*<span style="color: #000000"> screen, scroll down to the </span>*<span style="color: #000000">Columns to show</span>*<span style="color: #000000"> option and enter comma separated column numbers that must be displayed.</span>  
> Macro (inline-media-image)
</details>

<details>
<summary>Is there an option to change the font style?</summary>

<span style="color: #333333">Yes; i</span><span style="color: #333333">n the </span>*<span style="color: #333333">Edit 'excel' Macro</span>*<span style="color: #333333"> screen</span>**<span style="color: #333333">, </span>**<span style="color: #333333">enter the style under the </span>*<span style="color: #333333">Table style </span>*<span style="color: #333333">option and click </span>**<span style="color: #333333">Save</span>**<span style="color: #333333">.</span>

![image](media://cc4a49b6-7449-4755-b0cd-bd547d49acf4)
</details>

<details>
<summary>Is there an option to specify the table border width?</summary>

<span style="color: #000000">Yes; in the </span>*<span style="color: #000000">Edit 'excel' Macro</span>*<span style="color: #000000"> screen</span>**<span style="color: #000000">, </span>**<span style="color: #000000">enter the value in </span>*<span style="color: #000000">Table border width </span>*<span style="color: #000000">and click </span>**<span style="color: #000000">Save</span>**<span style="color: #000000">.</span>

![image](media://e936d785-5fb5-473f-9d32-c0b227639354)
</details>

<details>
<summary>Does this app work with the GoEdit app?</summary>

<span style="color: #000000">Yes; the </span>*<span style="color: #000000">Excel for Confluence</span>*<span style="color: #000000"> app works with the </span>*<span style="color: #000000">GoEdit</span>*<span style="color: #000000"> app. The </span>*<span style="color: #000000">GoEdit</span>*<span style="color: #000000"> app helps in editing Confluence attachments. Refer to </span>[<span style="color: #000000">this link</span>](https://bobswift.atlassian.net/wiki/spaces/SUPPORTS/pages/1002307785/How+to+perform+advance+calculation+in+Excel+macro+using+the+GoEdit+app)<span style="color: #000000"> for more details. </span>
</details>

> Macro (__confluenceADFMigrationUnsupportedContentInternalExtension__)