It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to Import Wiki 3.4.9 page/table into Excel? (How to set Wiki as data source in Excel?)

Alex V Apr 19, 2012

Hi, our company runs Confluence 3.4.9 and I cant seem to figure out how to import Wiki tables into Excel.

The scenario I am trying to solove is as following: We have 15 teams, each with their own inventory page on a Confluence Wiki (in a different table format). I would like to pull all 15 pages into Excel automatically, by setting up data sources. However, Excel doesn't seem to recognize Wiki the same way it recognizes Sharepoint tables. Instead it sees the whole page as one entity.

When I try to set up a data source "from a web page", I only get the header of the page, but not the actual data.

If I setup source "from text file", I get HTML + Wiki code, but I have been unable to find any Macros to help clean up the code.

I cant be the first one to try and solve this, so I was wondering if there is a plug-in for Excel or a Macro that can help me pull the whole wiki page or preferably just the tables?

Thank you very much,

Alex-

1 answer

1 vote
Renjith Pillai Apr 21, 2012

Interesting question.

Seems to be bit complicated way involving Excel and Wiki. A workaround would be to request teams to attach their individual Excel files directly in their pages, (and also use viewfile macro to see them on the page) and you use the attachment links directly from Excel (via WebDav) and do what ever reporting based on that.

Or do you can fetch the pages using Confluence Command Line and do a bit of scripting to generate csv file for Excel to operate on.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in Off-topic

Disney Live Action Reboots: Are you for or against?

Happy Friday Everyone! Today marks the international release of Disney's live action version of the animated classic Aladdin. I know that this movie was met with some controversy of over cast...

155 views 21 9
Join discussion

Community Events

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

Events near you