Linking Cells in a Confluence Table to an Excel Attachment

Matt
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 31, 2023

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

1 answer

4 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 31, 2023

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events