Looking for a macro in confluence that would allow the following
show a spreadsheet/table on the wiki page
content is pulled from a csv or excel file stored in onedrive
as the data file content is updated, so is the wiki
for ex, in center of wiki there is a table that is tied to the csv
user updates and saves some values, maybe add col's row's in the csv data file
user browsing the page either refreshes or as a new person joins the page after data file is saved, they now see the updated content
Hi @Sue Hannan ,
You'll be able to connect your CSV/TSV files as attachments and via urls (and Google Spreadsheets as well). All the updates made to the source file are immediately reflected on your Confluence page.
The recreated table can be further filtered, aggregated and visualized right in Confluence if required.
Hi @Sue Hannan
I am unsure about CSV but with excel files, you should be able to use the Office Excel Macro to show the file’s content and it should appear as a table.
Give the same macro a shot with excel or derive an excel file from the CSV file to get this working.
Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋♀️ ...
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