Read excel file contents and perform analysis in confluence

[emagnun]

Hello, 

I have an excel file thats updated daily by multiple users to track the product releases  (We keep the excel file in microsoft teams space)

Is there a way that I can link the excel file in my microsoft teams space to a confluence page? I would like to use this excel data in a confluence table and then create some confluence charts for the easy analysis. The idea is that the charts will be auto-updated whenever user adds a new product release information into the original excel file. 

What are my options?

[Katerina Kovriga _Stiltsoft_]

Hi @emagnun ,

We may suggest using our app - Table Filter and Charts for Confluence.

The add-on provides the Table from CSV macro that allows you to output a table from CSV or TSV data source. The macro supports outputting data from a URL/Google Spreadsheets or an attached file.

Then you may work with the data as with regular Confluence tables and filter them, aggregate, reuse, perform various calculations and visualize them.

The add-on provides the Table Filter, Pivot Table, Table Transformer and Chart from Table macros that will fully recreate Excel environment right in Confluence.

We'll be happy to organize a live demo for you and your team - please, book a suitable time slot here.

[emagnun]

Thanks for your advice. I can find "Table from CSV" macro here and I'll give a try with it. 

[emagnun]

@Katerina Kovriga _Stiltsoft_ 

Below is the erro that I get from macro. My filename contains "_" (eg: ABC_release_file.csv). Does it have to do anything with this error?

[Katerina Kovriga _Stiltsoft_]

It seems that the macro doesn't like the '{' and '}' symbols - try to replace them as %7B и %7D respectively.

Besides, the Sharepoint accounts may still prevent the macro from getting your data (even with the correct link format). Unfortunately, nothing can be done at the moment. We suggest using the Google Spreadsheets for such cases: here is a step-by-step guide how to connect them to Confluence. 

[emagnun]

Thanks Kateria. %7B and %7D worked , but as you mentioned, it looks like sharepoint access was still having issues and my org can't use google sheets unfortunately. 

[Nic Brough -Adaptavist-]

You can link to it, yes, but if you want to use it (in a confluence table or chart macro), you'll need to attach it to a page in Confluence.

However, I'd recommend dumping your spreadsheet (if more than one person is editing it, I can pretty much guarantee you that it's wrong and some of your people don't really understand it too).  I'd look to move release management into something that can do it well and automatically give you reporting too, Jira, Bamboo and Confluence are all good tools for it.

[emagnun]

Thank you for advice Nic. My idea is to just read that entire xls and generate a table in confluence. (Then i can play around with the table)

(More than one person edits the xls, but it's all separate areas in xls. Since it's in microsoft teams space, there are no issues when the file gets edited at the same time)