You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Is there any way to sensiably add a live Excel document that is on Share point shared with a large group of people into a Confluence Table Filter Macro?
we have multiple ad-hoc resources that refer to multiple events. on an excel workbook in sharepoint
Aim: is to pull the Excel sheet into a Table Excerpt, push that table excerpt into a confluence Table Filter which then displays the relivent infomation per event on each page.
so far I have found that Excel share point URL's cannot be embeded into an Table excerpt then seen by the Table Filter.
the next step i tried was to make an excel page that pulls a copy of the original Excel sheet, then exports it as a CSV file:
so far i have uploaded a CSV Excel file onto a page, pulled it into table excerpt via a Table From CSV Macro then loaded it into the Table filter, how ever this does not work,
the Table filter will see the Table from CSV when added on its own but the Table Excerpt will not carry a Table from CSV MACRO.
I am also debating doing the same but with an Import Table from JSON MACRO.
I understand i am probably doing something unorthadox to the norm.
is there any suggestions to get this or are there any Add ons to achive this?
Hi @Richard Moore ,
Our app can't work with the data coming from the Sharepoint directly due to its security: you won't be able to insert a link to your Sharepoint sheet via the Table from CSV macro and recreate a live table in Confluence. With Google Spreadsheets it is possible though.
What concerns your second option, then it should work unless I misunderstood you. If you have a .csv file attached to your page, then you can recreate it as a table via the Table from CSV macro.
This Table from CSV macro may be wrapped in the Table Excerpt macro and reused via the Table Excerpt Include macro several times. These Table Excerpt Include macros can be then wrapped in the Table Filter macros for independent filtration across your pages.
"This Table from CSV macro may be wrapped in the Table Excerpt macro and reused via the Table Excerpt Include macro several times. These Table Excerpt Include macros can be then wrapped in the Table Filter macros for independent filtration across your pages."
This is what I have been trying to do:
Current test setup is:
Excel.csv file attached to page, > Wrapped in a CSV to table Marcro> Warpped Table excerpt Macro/ Table excerpt include macro> Wrapped in a Table Filter Macro
though i have found that at the "Warpped Table excerpt Macro/ Table excerpt include macro" stage i get the output error
"No Table Excerpt macro with name CSV-Test found. Did you publish the page with the Table Excerpt macro?"
i guess this has something to do with it being saved in a One Drive?
So, you have your .csv file attached to the page and the page is published.
The next step is to recreate your table via the Table from CSV macro: find this attach by its name and see your table in the macro preview.
Then you wrap this Table from CSV macro in the Table Excerpt macro with the CSV-Test name.
Then you again publish the page.
After that you insert the Table Excerpt Include macro (on the same page or any other pages) and try to find your CSV-Test excerpt.
If the page with the Table Excerpt is not published, the Table Excerpt Include doesn't know that a new excerpt is in the system.
That's why you have this error that prompts you to publish the page with your excerpt.
If the page was published but you have the same error, it means that the names inside your Excerpt and Include are not alike. For example, your Excerpt may be called CSV_Test but your Include searches for CSV-Test.
It can pull data from Google Sheets/Google Drive and custom urls that may be public sites and your corporate storages where your Confluence instance is whitelisted.
Not sure that OneDrive url will work here.
An update from our side regarding the OneDrive files and the Table from CSV macro: there is a hack how to get a direct download link to your OneDrive file.
So, we've checked it and you may try the following:
For us the file is recognized by the macro and its contents is displayed in a proper tabular way.