Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

    Advertisements
  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand
  • Advertisements

Named Items in Excel Web Access Web Part

Posted by Paul on December 2, 2015


In this article we can explore how to use Named Items in Excel Web Access web part.

Named Items

Named Items is a feature of Excel which allows Naming few cell area. This makes us easier to integrate the Excel workbook with SharePoint pages. We can show different areas of the same sheet Or different sheet in multiple Excel Web Access web parts.

Create Excel Workbooks

Create an Excel workbook with 2 charts as shown below.

image

Now select the cells for Chart1 and Right click to get the following menu.

image

You will get the Name dialog box as shown below. Enter a name Chart1 without spaces.

image

Now repeat the same for Chart2 area.

image

SharePoint

Upload the above workbook to SharePoint document library. Create a new page using the Add Page menu item.

image

Insert two Excel Web Access web parts into the page.

image

For the first web part:

1. Choose excel document

2. Set Named Item to Chart1 by typing

image

Now go to the second web part & repeat for Chart2 named item.

Save the page & you can see as shown below.

image

You can see that different parts of the sheet are displayed here.
image

Named Items can be used to display information from multiple sheets too.

References

http://bit.ly/1kL5KNg

Summary

In this article we have explored how to use Named Items in Excel Web Access web part.

Advertisements

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s