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

Using Excel Web Access Web Part

Posted by Paul on January 17, 2015


In this article we can explore how to use the Excel Web Access Web Part.

Excel Web Access Web Part

Following are the properties of Excel Web Access Web Part

· Used to display an Excel workbook in browser

· No need of Excel client application

· Excel workbook appearance can be customized

· Part of Excel Services

Using Excel Web Access Web Part

Please follow the steps below to use an Excel Web Access Web Part.

Step 1: Create a Page

Open your site & create a new page and name it as Excel.

image

Step 2: Add Web Part

Edit the page & choose insert a web part option. From the Business Data group choose the Excel Web Access web part.

image

Step 3: Select File

Click on the link highlighted below.

image

In the appearing tool pane select the excel work which was uploaded to a document library

image

For the time being I am using a sample excel file as shown below.

image  

Step 4: Test Page

Click Ok to the tool pane & save changes to the page. You should be able to see the excel file within SharePoint page as shown below.

image

Please note the sheets as well. For downloading the file you can use the File > Save menu.

Please note that you don’t require MS Excel to be installed in the machine. The entire excel cells rendered through Excel Services application & browser.

References

https://technet.microsoft.com/en-us/library/ee424405(v=office.15).aspx

Summary

In this article we have explored how to use the 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