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
Page/Attachment/Sheet/Range
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.
Thanks
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.