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
There's a lot of examples of importing a spreadsheets either by copying/pasting or importing but having played about with these I believe I need a different use case.
Page 1 - Confluence page which displays the output from an attached Spreadsheet using 'Table Spreadsheet Include'. The points to the spreadsheet attached to this page and displays in in an un-editable table. (This I have done successfully)
Page 2 - A Confluence page with a standard Table for editing BUT the column is the first column from the Page / Spreadsheet on Page one.
I can do this as below using 'Table Spreadsheet Include' again but I need to reference each cell (range) in the macro for each one to appear in the table i.e.
Page 2 Table:
Column1 Column2 Column3
'Table Spreadsheet Include' New Data New Data
of Excel on Page 1
Is there an easier way to link cells in a confluence table to cells in a spreadsheet?
Or is there an easier way of completing the above method without needing to edit each 'Table Spreadsheet include' in column 1 of Page 2's table.
Any insights appreciated.
Hi @Matt ,
The Table Spreadsheet Include macro is indeed used if you have a big Table Spreadsheet macro somewhere and you need to reuse and display a specific cells' range somewhere else.
Then if you need to take this specific information and add some other data to it, you may wrap this Table Spreadsheet Include macro in the Spreadsheet from Table macro.
This data will be automatically turned in a spreadsheet and you will be able to add other columns to it.
Hope I could give you some hints for the case.