Use of Office-excel macro for filtering tables

[amiram_fuerst]

If i ma using Office-excel macro, can viewers without Office view and filter the sheet?

[Andrey_Khaneev__StiltSoft_ · Accepted solution]

Hello @amiram_fuerst

You can use Table Filter macro with Office Excel macro to view and filter Excel sheets.

[amiram_fuerst]

Does this mean that i have to buy also the Table filter?

[Andrey_Khaneev__StiltSoft_]

Yes, this is a paid app, but you can get a 30-day free trial.

[Jaclyn_Mazzarella]

Hi Amiram, 

You can give Excellentable- Spreadsheets for Confluence a try for free for 30 days! Read more about it here - https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Spreadsheets-for-Confluence-Put-an-end-to-table-nightmares-with/ba-p/1236419

[amiram_fuerst]

Ecellentable -Spreadsheets for Confluence does not give me any added value for just using a link to Google sheet (which i already have).

I want to use Confluence tables, not a separate table which is edited not as a part of the Confluence page. 

[Jaclyn_Mazzarella]

Hi Amiram, You can add your current Google sheet to the Confluence page using Excellentable. It will then become an active spreadsheet inside your Confluence page where you can then filter and sort through the data.  This will also allow you to share the filtered sheet to other users in Confluence without the need for any other software, ie: Office. 

Feel free to review some demo videos on Excellentable: https://www.youtube.com/playlist?list=PLE9WUHg1PW437az1BWvb8pjw5rxfAj6DV

Hope this can help in the future!

[amiram_fuerst]

Hi Jaclyn,

I don't understand your statement "...You can add your current Google sheet to the Confluence page using Excellentable". How?

[Jaclyn_Mazzarella]

Hi Amiram, if you download a free trial of Excellentable,  you are able to insert an Excellentable into your Confluence page (as a macro) and then import your Google Sheet into that Excellentable. 

Think of Excellentable as a live spreadsheet editor that sits inside your Confluence page. 

If you are interested, I can set up a demo of the product for you. 

[amiram_fuerst]

The import is from CSV not Google sheet directly

[Andrey_Khaneev__StiltSoft_]

There is the Table from CSV macro that imports tables from different data sources (attachment and URLs).