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; } } }

Excel Macro

Anders Bruhn Fagerjord

I have embedded an Excel spreadsheet using the Excel macro. The sheet have columns A - AU. On saving I have used "Hide" function on several columns. When displaying sheet in Confluence all columns A - AU is displayed.

Is this just not possible to achieve with the Companion App?

Kind regards Anders

Accepted answers

Katerina Kovriga _Stiltsoft_

Hi @Anders Bruhn Fagerjord ,

I think you can't achieve this unless you use any additional apps.

For example, we can suggest trying our Table Filter and Charts for Confluence app.

The first step will be using the Table from CSV macro (supports attachments and URLs) macro to embed your Excel table onto Confluence page.

The second step is to wrap this macro into the Table Filter macro where you'll be able to hide columns, filter your table and perform calculations.

Shardul Juyal {Addteq}

Hi @Anders Bruhn Fagerjord

While the feature is not available in the companion app, You can try our Excellentable spreadsheet.
With Excellentable you can import a .xlsx with hidden rows/columns or just hide rows/columns on the fly.

Oki__PolarisOffice_

@Anders Bruhn Fagerjord I would like to recommend Polaris spreadsheet for Confluence. It enables you to edit an excel file in a confluence page without any conversion. It also offers the advance view mode that supports filter, freeze pannel, search and etc.

Please check how to insert your excel files in confluence pages. https://www.youtube.com/watch?v=OELp_2G62oI

All comments

Katerina Kovriga _Stiltsoft_

Hi @Anders Bruhn Fagerjord ,

I think you can't achieve this unless you use any additional apps.

For example, we can suggest trying our Table Filter and Charts for Confluence app.

The first step will be using the Table from CSV macro (supports attachments and URLs) macro to embed your Excel table onto Confluence page.

The second step is to wrap this macro into the Table Filter macro where you'll be able to hide columns, filter your table and perform calculations.

Anders Bruhn Fagerjord

Hi @Katerina Kovriga _Stiltsoft_

I'll try to follow your suggestions. Thanks.

Anders Bruhn Fagerjord

Then this is tested. In the process I found that the Table Filter macro gets embedded when you use the Office Excel Macro.

Filtering is possible, even if its time consuming to get done. In larger projects you may add xls sheets all the time and then it gets complicated.

When using the Hide function in Table Filer, remember to click on Save in the filter drop down.

I have added a rating of the app, trying to explain the issues. And the main issue of course is that the Office Excel Macro don't display the sheet as it is saved in Office.

Thanks for your help and I'll wait for an update of the Office Excel Macro before I embed more xls sheets. I will rather use a link to access the file, even if this is not what I really like to do.

Katerina Kovriga _Stiltsoft_

Try the Table from CSV macro - if you use Google Sheets, then you'll be able to connect your sheet to Confluence via its URL.

It is rather convenient because you'll be able to update you Google sheet and all the changes will be automatically reflected in Confluence.

And then you'll be able to filter/hide columns with the Table Filter macro.

Shardul Juyal {Addteq}

Hi @Anders Bruhn Fagerjord

Oki__PolarisOffice_

Please check how to insert your excel files in confluence pages. https://www.youtube.com/watch?v=OELp_2G62oI

Welcome!

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

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

macro