'Table Spredsheet Include' Macro

Question

Hi,

I was trying to create a table or spreadsheet on a confluence page which pulled / referenced data from an attached excel spreadsheet.

I realized that this could be done in two ways.

1) Attach Spreadsheet to the confluence page and use 'Table Spreadsheet' Macro to view the data as an embedded spreadsheet

2) Attach Spreadsheet to the confluence page and use 'Table Spreadsheet include' Macro to view the data as Table.

The latter was my preferred option but upon trialing it in various instances I realised the 'Table Spreadsheet' include macro only worked when 'Table Spreadsheet' had been previously used and the excefilename.render and excelfilename.tfss had been created.

Surely I should be able to attach a spreadsheet to a page and use 'Table Spreadsheet Include' without having to use 'Table spreadsheet' first?

Thanks

Stiltsoft support · Answer

Hi @Matt Sharmer ,

Indeed the Table Spreadsheet Include macro was developed to reuse the parts of the Table Spreadhseet macro across your Confluence.

The behavior that was kindly explained by @Marc -Devoteam- is correct.

Marc -Devoteam- · Answer

Hi @Matt Sharmer

I see you use the app Table Filter and Charts for Confluence.

And according to their documentation the option 2 is the way this is working, as the include needs the Table Spreadsheet Macro.

The Include macro's purpose is to make an excerpt of the spreadsheet on other Confluence pages.

It has the same way of working as the ootb Confluence macro's.

* Excerpt
* Excerpt Include

If you are thinking their should or could be another way, I suggest you to reach out to Stiltsoft support and mention your question.