nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Update Table automatically when Excel is updated

Francis Atienza

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.

Accepted answers

Andrey Khaneev _StiltSoft_

Hi Francis,

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

Table Excerpt and Table Excerpt Include macros can include the Office Excel macro from those pages.
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.

All comments

Andrey Khaneev _StiltSoft_

Hi Francis,

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

Table Excerpt and Table Excerpt Include macros can include the Office Excel macro from those pages.
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.

Francis Atienza

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:

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.

Andrey Khaneev _StiltSoft_

Here is what I got.

Pages with Excel files:

The report page:

Inner Table Transformer:

Outer Table Transformer

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'

Katerina Kovriga {Stiltsoft}

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence