Display dynamic formulas from excel sheet

AME_87ch9g

I am looking display multiple time zones on my teams home page. However since I do not have access to develop user macros (company restrictions), I tried displaying time zones using formulas from an Excel doc through an Excel Macro. 

The problem is that these formulas do not update. They remain static even as the page refreshes.

Is is possible to display dynamic excel formulas with the out of the box Confluence Excel Macro?

Katerina Kovriga {Stiltsoft}

Hi @AME ,

As usual standard Confluence macros work with static content (except such macros as Jira Issues and Page Properties Report macro).

So try to use additional plugins, for example, the Table Filter and Charts for Confluence app and its Table from CSV macro that can output data from Google Sheets/Google Drive, and all the changes will be reflected immediately.

Besides with the help of the same app and its Table Transformer macro you will be able to count and display your time zones right in Confluence:

Type in the following custom SQL query:

SELECT *,
FORMATDATE(DATEADD(hour, T1.'GMT' + ("today"::Date->getTimezoneOffset() / 60), NOW())) AS 'Time'
FROM T1

And set the corresponding Date format (hh:mm):

As a result you'll get the following table that is always up-to-date: