Hi there!
I'd like to create a table with multiple sheets in Confluence, the easiest way perhaps is to upload the existing Excel sheets but it doesn't work. So I want to insert a table directly in the page but find no way to add sheets like Excel, any idea to finish this action?
Hi @Donghua SHEN ,
Welcome to the community !!
Please see if the below steps helps you.
Go to your confluence page, click o action menu (3 dots) --> attachments and upload your excel file.
Once the file is uploaded, click edit on the page, add "Excel" macro and select the uploaded excel file and save the macro and then publish the page.
More details in https://support.atlassian.com/confluence-cloud/docs/insert-microsoft-office-macros/#InsertMicrosoftOfficemacros-OfficeExcelexcel
Hi @Donghua SHEN ,
Scroll to the end of the macro section, you can see the different sheets mentioned.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Donghua SHEN ,
If you are open to 3rd party solutions, we can suggest using our Table Filter and Charts for Confluence app and its Table Spreadsheet macro.
You'll be able to insert and edit spreadsheets with multiple sheets from the page view and page edit mode.
Besides with the help of the Table Spreadsheet Include macro you'll be able to reuse your sheets across your Confluence and display custom cell ranges wherever you need.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I’ve faced similar challenges when trying to integrate my Excel data into Confluence. I ended up just creating separate tables for each sheet on the page, which wasn’t ideal but got the job done. If you want to keep everything organized, consider using the “Include Page” feature to pull content from other pages instead. This way, you can keep your data structured without too much hassle.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks @Rilwan Ahmed , I managed to insert the table into the page and can edit one of the sheets now with your help. But still got the display problem that other sheets can not be displayed in the page (only displayed the first sheet), any solution for this please?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.