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

Table Filter macro and excel Share point Intergration

Richard Moore_a06fgt

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?

Accepted answers

All comments

Stiltsoft support

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.

Richard Moore_a06fgt

"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?

Stiltsoft support

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.

Richard Moore_a06fgt

ok thank for that done some poking around: and the Table Excerpt include working again.

I guess the next question is can Table from CSV pull from a One drive URL?

Welcome!

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

Quick Links

Find more posts tagged with

confluence

csv

cloud

filter

macro

ms-excel

questions-for-confluence

table

json

table-filter

table-filter-and-charts

table-filter-charts-spreadsheets