FAQs for the Excel for Confluence app

Owned by Manisha Kharga
Last updated: Feb 07, 2020 by Smita Nair

Overview

This page presents the answers to the most frequently asked questions about the Excel for Confluence app.

FAQ

 How can I export or download an Excel file using this app?

Yes, we can download an Excel file using this app.

Edit the Excel for Confluence macro, check the Allow download and export option and click Save.  

 How to display data from an Excel file?

Edit the Excel for Confluence macro, enter the Name of attachment, and, click Save.  

 How to read data from an Excel attachment that is in another space?

To read from an Excel attachment that is in another space, edit the Excel for Confluence macro in the relevant page.

  1. Enter the SPACEKEY:Page title in Page for attachment. The value entered here must be that of the space key and title of the page that the app must access.
  2. Select the required Excel file from the list in Name of attachment and click Save.
 How can I select or display the sheet name from the workbook?

In Edit 'Excel' Macro screen, scroll down to select the Show sheet name before the table option, and click Save.

In the following screenshot, "Project" and "Issues" are the names of worksheets in the specified workbook:

 Is there an option to sort column data that is read from an Excel file?

Yes, use the Show sort icon option to make column data sortable.

In the Edit 'excel' Macro screen, select the Show sort icon option and click Save.

 How to calculate the sum of numeric data that is read from an Excel file?

In the Edit 'excel' Macro screen:

  1. Enter a comma separated list in Column types. Refer to this document for more information about field and various type indicators.
  2. Select the Auto total row option and click Save.
 Can I display only selected column(s) from the Excel sheet?

Yes, the Excel macro has an option to display the selected column(s) from the Excel sheet.

In Edit 'excel' Macro screen, scroll down to the Columns to show option and enter comma separated column numbers that must be displayed.

 Is there an option to change the font style?

Yes; in the Edit 'excel' Macro screen, enter the style under the Table style option and click Save.

 Is there an option to specify the table border width?

Yes; in the Edit 'excel' Macro screen, enter the value in Table border width and click Save.

 Does this app work with the GoEdit app?

Yes; the Excel for Confluence app works with the GoEdit app. The GoEdit app helps in editing Confluence attachments. Refer to this link for more details.