Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Excel sheets

Sam Betlem August 27, 2019

Hello we are trying to have an excel sheet to display correctly on a confulence page. 

I have uploaded an excel xlsx file onto the webpage. The link is present and working, i then add the excel macro onto the page and link the previously linked file. 

Once published i get the error attached.ConfluenceError.PNG

If there is a way i can get this working please let me know.

Cheers

 

2 answers

0 votes
Jaclyn Mazzarella
Atlassian Partner
August 30, 2019

Hi Sam, 

If this helps any, you can give the app - Excellentable - Spreadsheets for Confluence a try!

0 votes
Mike Rathwell
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 27, 2019

Hi @Sam Betlem 

It seems like you're somehow ending up with the wrong macro in there. Check your page and make sure you inserted the "Office Excel" macro and you are explicitly pointing at the Excel file in the configuration for the macro.

Sam Betlem August 28, 2019

Hi @Mike Rathwell 

 

I have attached two screenshots of how the edit view looks and the macro i have added.


ExcelMacro.PNGEditpagemode.PNG

Im sure im using the Office excel, i also thought it odd that it was referencing a PDF instead of xlsx file, but i can confirm that i am using what i would assume is the correct macro.
Can you confirm that im using the right setup?

Mike Rathwell
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 28, 2019

Good morning @Sam Betlem ,

Can you click the "edit" on that macro and paste the screenshot of the configuration for it?

Sam Betlem August 29, 2019

Hey @Mike Rathwell 

I discovered the issue. To get the excel sheet to work correctly i had to split the sheets of the excel into separate documents and then link them in. This gave printed the results, to be honest after looking at the layout i found it easier to print the excel sheets as PDF's then used the PDF macro which worked fine. 


Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events