Understanding Excel Mashups

So, what’s this now?  I ran into an interesting implementation of Excel, that I not only used, but wanted to share with my readers.  It’s called an ‘Excel Mashup’ and information about it, including a live sample can be found on the main website.

In a nutshell, it’s the ability to use Excel visualizations with any HTML table.  These visualizations appear as overlay to the web page with the table and they include tabular (with row-level data bars automatically included) and a couple of line charts.  Also you can sort, filter or print as shown in the sample from the Excel Mashup site below.

 

You can also open the mashup in Excel on the desktop or via Excel web access as shown below.

Using this new functionality to an existing web page is simple.  As per the instructions on Excel mashup website, you just fill out a couple of dialog boxes to specify the Excel button size, Chart title, etc… and then copy and past the resulting HTML into your webpage.

Another interesting set of functionality is an included Excel mashup plug-in for WordPress.  Here you use WordPress short codes (rather than HTML) , such as ‘[excel-interactive-view style=”Standard”]’ to specific your Excel Mashup Parameters.  I made a short video about adding an Excel mashup to the TKP website – enjoy!

Note: after I recorded the video, I noticed that some of configurable parameters (the attribution) only show up in the Excel Web App view (not the overlay).

I’d be interested to hear whether (and how) you are are using Excel Mashups – leave comments on this blog post.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s