Friday 6 April 2018

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 in the following,

Create an Excel workbook

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

Define name

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

get the Name dialog box

Now repeat the same for Chart2 area.

new name

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

Add a page

Insert two Excel Web Access web parts into the page.

Excel Web Access

For the first web part:
  1. Choose excel document.
  2. Set Named Item to Chart1 by typing.

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

Save the page & you can see as shown below.

Excel test

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

No comments:

Post a Comment

Featured post

Data connections in Infopath forms

https://www.qdoscc.com/blog/how-automatically-retrieve-current-username-infopath-sharepoint-list-form

Popular Posts