Connecting Visio and Excel Web Access controls in SharePoint 2013

I have recently been working on an FM project where I have spaces and personnel shapes in Visio floor plans data linked to Excel tables. I constructed a number of related tables in an Excel workbook and wanted to demonstrate the relationships. I decided that this is best explained with a combination of a diagram and sample data , so this article describes how to connect Visio and Excel web parts together in SharePoint 2013 web pages, without code.

Preparation

First, I constructed an Excel Services workbook and a Visio Services document.

Excel Workbook Tables

The Excel workbook has a number of tables on similarly named worksheets.

image

Visio Diagram Shapes

I modified the Object Hierachy master shape, from the COM and OLE stencil, to include a Shape Data row called Table, and displayed the value of this as text.

 

image

 

SharePoint Web Part page

I then added the Visio Services diagram and Excel Services workbook into adjacent web part zones in a SharePoint 2013 web page.

image

The Visio Web Access control

I edited the Visio Web Access control to expose the Table shape data items to web part connections, and configured the connection between the two web parts to use this as the field name.

image

The Excel Web Access control

In fact, you can define the connection in either the Visio or Excel Web Access control, as the Connections menu option becomes available on each web part when there are suitable web parts in a page.

image

Note that the other option for the connection is to simply get the Workbook URL from Visio shape data item.

Conclusion

Setting up this web part page was actually quite simple, and really helps me explain the relationships and data. I can select an item in the Visio diagram, and the related worksheet is displayed in Excel.

It is unfortunate that it is not possible for me to publish the web page for public consumption …

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

davecra.wordpress.com/

Microsoft Office Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Shapes, Stencils, Drawings Templates, Tutorials, Tips & Developer Info for Microsoft Visio

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...

%d bloggers like this: