Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Update Table automatically when Excel is updated

Hi all,

I am looking for a plug-in or any kind of solution that will help me accomplish this: I have several confluences pages. One is an overview page with a table containing details such as item name, date created, etc.  The names link to another page with an embedded excel sheet which contains more specific details about that item.

I want the overview table to automatically reflect some columns from the embedded excel page. For example, when I change the date created on the excel page of an item, I want the date created under that item to say the same in the overview table.

 

Is there a plug-in that will help me do this? I will also take alternative solutions.

1 answer

1 accepted

Hi Francis,

I think it is possible to do with the help of Table Filter and Charts app:

  1. Table Excerpt and Table Excerpt Include macros can include the Office Excel macro from those pages.
  2. Table Transformer macro can lookup tables and extend the overview table with data from included Office Excel macro.

I can describe those steps in more details if you tell more about your case.

Hi Andrey,

Thanks for the answer. I will look into those things you mentioned. For my case, we have a page that has a table of projects. Here is a sketch of the table that is similar to what I am working on:

 

table.PNG

 

Project A, Project B, etc are hyperlinks that leads to another page that contains an embedded excel that goes into more detail about that particular project. Here is a sketch of that excel sheet:

 

project details.PNG

 

What I'm trying to do is capture some cells of this embedded excel and reflect it to one of cells from the table of projects. For example, lets assume that the excel sheet above is for project A. I want to capture Actual Start Date of Req and output it to Req Date in the first table. If I change that date on the excel sheet, I want the first table to automatically update the new information.

 

Ignore the discrepancy on the test and dev  being empty in the excel project details and the table having dates for it. I was just trying to make a quick sketch. 

Here is what I got.

Pages with Excel files:

2019-05-14_14h58_18.png2019-05-14_14h58_27.png

The report page:

2019-05-14_15h03_16.png

2019-05-14_15h04_18.png2019-05-14_15h05_46.pngInner Table Transformer:

2019-05-14_15h06_57.png2019-05-14_15h09_04.png

Outer Table Transformer

2019-05-14_15h10_08.png

SELECT 'Title' AS 'Project', 
FIRST('Creator') AS 'Creator',
ARRAY(T2.'Actual Start Date')->0 AS 'Test Date',
ARRAY(T2.'Actual Start Date')->1 AS 'Dev Date',
ARRAY(T2.'Actual Start Date')->2 AS 'Req Date'
FROM T1 LEFT JOIN T2 ON T1.'Title' = T2.'Project' GROUP BY 'Title'

Hi @Francis Atienza , here is our latest update for the Table Excerpt/Table Excerpt Include macros: now you can show page titles of included tables automatically. Just tick the Show page titles of included tables field and you'll see the links to the pages with Excerpt macros:

Mon 2-1.png

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Announcing Team Calendars in Confluence Data Center

Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond.  A long time favorite,  Team Cale...

198 views 0 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you