nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Link/show Office Excel Macros embedded in several Conflunece pages on one single Confluence Page

Gregor Balsiger

I got several Office Excel Macros on several Confluence pages (each of them in a different project space) and wish to have one additional Confluence page where I could see and acces these Excelsheets just in the same way as I can do it on their origin pages, for that would give me a great overview about the content of these Excelsheets. I wish to see the images / acces to the Excelsheets as described above rather than just have hyperlinks to the specific Confluence pages. Is there a way to do so? Thank you.

Accepted answers

Shardul Juyal {Addteq}

I think you can simply use Excerpt include macro.

Create a new excerpt in the source page.
Put the attachments inside the macro
Refer to this excerpt in the destination page.

I had created this video a few days back, for a similar use case (The spreadsheet app is Addteq's Excellentable), but in case you want to use it with normal attachments it should work too

You should be able to do access control as well using this tool.

All comments

Hyrum Steffensen {Appfire}

Hello Gregor,

If you look at the Hierarchical File System Attachment Storage for Confluence, it will give you a sense of how attachments are stored in Confluence. In theory, you can link multiple pages to one attachment. For instructions on how to do so, see this Atlassian documentation. If this does not solve the issue according to your requirements (or would like to automate the process), please let me know and I will look deeper into the question.

Regards,

Hyrum

Katerina Kovriga {Stiltsoft}

Hi @Gregor Balsiger

We can suggest using our app - Table Filter and Charts for Confluence - to collect the original tables, links and additional information about your Excel macros on the one Confluence page.

The app is mostly used for table filtration, data aggregation and visualization, but it also provides the Table Excerpt/Table Excerpt Include macros that can collect multiple-row tables across your Confluence instance.

Wrap your Excel macro into the Table Excerpt macro and assign a unique across other Excerpts, but the same for each Excel macro name ("123" for my example):

Thu 4-2.png

The Table Excerpt macro won't be visible when you publish your page:

Thu 4-1.png

Then go to the page where you want to collect all the Excel macros and use the Table Excerpt Include macro:

Thu 4-3.png

Here you need to specify the Excerpt's name ("123" for my example) and where to search for the Excerpts (you'll have several options to choose from).

You may also choose what meta data to show: link to the page containing your Excel macro, its parent page, space, label, etc.

Thu 4-4.png

Hope this may help your case.

Shardul Juyal {Addteq}

I think you can simply use Excerpt include macro.

Create a new excerpt in the source page.
Put the attachments inside the macro
Refer to this excerpt in the destination page.

I had created this video a few days back, for a similar use case (The spreadsheet app is Addteq's Excellentable), but in case you want to use it with normal attachments it should work too

You should be able to do access control as well using this tool.

Gregor Balsiger

Thank you, that's what I'm looking for, kind regards to all

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server