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

Excel with Parameters

Posted by Paul on February 10, 2015


In this article we can explore how to use Excel Parameters along with Excel Web View web part.

Parameters

Parameters are Names associated with cells in an Excel workbook. Parameters allows users to change the cell values while in the Excel Web View web part.

image

Excel Web View web part does not allow editing of cells.

Excel 2013

For the experiment I am using Excel 2013 client application.

image

Create Parameters

Create a new Excel work book. Add the following cell values and a chart.

image

Click on the FORMULAS tab.

image

Now click on cell A1 and then on the toolbar Define Name button. In the appearing dialog enter the name as Parameter1 as shown below.

image

Repeat the same for other 4 cells and name them respectively. You can see the Name Manager to ensure all the cells are named correctly.

image

Now we are ready with our Parameters.

Expose Parameters

Now we need to expose the parameters in Browser View options. Those parameters exposed will be workable when the workbook is interacted through a browser.

image

In the appearing dialog choose the Parameters tab and select the parameters as shown below.

image

Save the file & now you are ready to deploy the workbook to SharePoint.

Inside SharePoint

Upload the above workbook to a document library, create a new page & insert the Excel Web Access web part into it. Then select the above workbook & Save changes to the page.

You should be able to see the Parameters in the right pane as shown below.

image

You can try changing the parameter values and click the APPLY button. The graph too should change.

References

http://bit.ly/19hRHso

Summary

In this article we have explored Excel Parameters with Excel Web View 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