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; } } }

Automatically update of page content from Excel VBA

Muhammed Cihad Akkaya

Hello, I have multiple excel files regarding my projects in my computer and I have also pages for every project in my company's confluence space. So when the excel is updated, I wanna update automatically the respective page on confluence. For a very new to confluence guy, I come across with REST API, but I couldn't be sure that if it works for this task. Another solution I think of is finding a way of updating the source codes of the pages automatically from VBA, but how? Even both are possible can you please guide me which one I choose and what is the route map for succeeding in this?

BTW, when I have a look at the example REST API codes for content update, they are looking very different than the page source code, In the source code, which part of the code is indicating which part of the content is obvious but for the REST API it's quite complicated, if you can explain the difference as well, it'd be appreciated.

Thanks

Muhammed

Accepted answers

All comments

Kishan Sharma

Hi @Muhammed Cihad Akkaya Welcome to Atlassian Community!

Can't you directly attach the Excel to your confluence page and modify it through confluence itself ? If that works for you, it is pretty straight forward.

Muhammed Cihad Akkaya

Hello @Kishan Sharma,

Thank you very much for the fast reply first, but this doesn't work for me because I want to use a specific page template on Confluence, and in every update of excel, I have other different tasks to be done additionally confluence page update.

Kishan Sharma

Thanks for confirming @Muhammed Cihad Akkaya In that case, please refer comment on this thread to know how you can create a page on confluence using a specific template and write data to it.

Muhammed Cihad Akkaya

Thank you @Kishan Sharma, but this doesn't really address my question. I have already pages in a distinct template, my question is more related to automatically updating multiple pages from vba.

Katerina Kovriga {Stiltsoft}

Hi @Muhammed Cihad Akkaya ,

We can suggest browsing the Marketplace - it seems that there should be even free apps that allow you to create good-looking tables from CSV files/URLs/Google Docs. So, you'll be able to update your local table and all the changes will be reflected on the Confluence page.

As for our own app (that is Table Filter and Charts for Confluence), it is a paid app which main purpose is to replace Excel and filter, aggregate, calculate and visualize table data right in Confluence. But it also provides the Table from CSV macro that may accomplish your case.

sanjeev kumar_9a4cx7

@Muhammed Cihad Akkaya Hi, Did you get the approach to solve this problem? Please help

Welcome!

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

Quick Links

Find more posts tagged with

confluence

server

confluence-server

ms-excel

update

visual-basic