The Detail Department

  • Our Services
    • Strategy
    • Analysis
    • Implementation
    • Training
  • Applications
    • Salesforce
    • Confluence
    • WordPress
    • Other Apps
  • About Us
    • Jodie Miners
    • Projects
    • Privacy Policy
  • Blog

© The Detail Department Pty Ltd 2016

You are here: Home / confluence / Excel, Charts and SQL in Confluence

Excel, Charts and SQL in Confluence

31-Jul-2012 by Jodie Miners

One of the disadvantages of Confluence is how difficult it is to use Tables, especially when they get large. One of the options is to keep tabular data in Excel and display the contents in Confluence. Or better still, get the data direct from a SQL Server to display in Confluence then show that data as a Chart.

Confluence 4 seems to be a bit better at handling tables, but Excel is still the king for displaying and working with Tabular data.

Some resources to help with showing Table data are:

  • Viewing Office Files in Confluence – Yes, you can display Office files directly in Confluence but the options are limited and it is static content only. Also, see the screen shot of the difference between Excel content shown in Confluence 3.5 (left) and Confluence 4 (right). I can cope with the colour change, but please don’t mess with my paragraphs.
  • Editing Excel Filed from Confluence – even though Confluence says this is possible, I would avoid it – it is not a very good experience at all. Just download the file, edit it and then re-upload it to the page.
  • Excel Plugin – way more options for formatting the Excel contents in Confluence. Has the ability to sort columns, number formatting, colours etc. The formatting options can also be used with standard Confluence Tables or CSV data.
  • SQL Plugin – run queries directly from the Server and display them in Confluence.
  • Chart Macro – a standard Confluence macro that can be used to great effect.
  • There are some excellent examples of all these options in the Confluence Reporting How To – a really great document showing how table data can be shown in Confluence.
  • For Advanced users, use the Reporting Plugin to turn Confluence into the source data for your reporting. This plugin is amazing with what it can do.

Some tips are:

  • Keep your content and formatting simple.
  • Keep the original Excel files attached to the page – don’t have another copy on your file share or your local PC.
  • Show only one or two tables or charts on each page – create more pages for different content.
  • Use the sorting, highlighting and titles options to make the tables more interactive and user friendly.
  • Keep your data updated (this is where getting data directly from the source via the SQL macro works really well).
  • Give people a reason to visit the page and see this content.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • More
  • Click to print (Opens in new window)

Filed Under: confluence

Jodie Miners

Jodie Miners is the Director of The Detail Department. She can help your business move from vision to reality with the right systems for your business.
Her eye for detail and her understanding of the ‘bigger picture’ will create and integrate seamless business systems. Read More about Jodie…

View My Blog Posts

Comments

  1. Jodie Miners says

    22-Oct-2012 at 2:39 PM

    Hi Marves,
    Try the Table Filter Plugin http://stiltsoft.com/table-filter/index.html It says that the Macro’s body can be another macro that produces a table.
    The table can be produced with the Excel Plugin https://marketplace.atlassian.com/plugins/org.swift.confluence.excel (or even try the viewfile macro first).

    I haven’t tried this combo for real, so let us know how you go.

  2. Marves says

    22-Oct-2012 at 1:31 PM

    Hi Jodie, I wonder if you can help me out. I’m new in using Confluence and is not that much of a techie. Do you know if it’s possible for me to show the cell filters on an excel sheet attached on the Confluence page? I’m thinking it’s not because I think it’s just a display function that the excel macro has on the Confluence but nevertheless, I’m taking my chances. 🙂

    Thanks in advance!

Search this Website

Subscribe to Blog Posts

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Latest Posts

Advice for Salesforce Career Progression

So, you want to learn Salesforce?

Your Business Needs More Than Just a Website

Q and A: Apps for Service Delivery

Using Wufoo Forms with Salesforce

Integrations are The New Black

We need to talk about Documentation

Tools to help write help documents

Moving away from Command and Control

My ultimate guide to getting started with Gmail