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

Display Worksheet using Excel Services in SharePoint 2013

Posted by Paul on December 27, 2014


Display Worksheet using Excel Services in SharePoint 2013

In this article we can explore how to display an Excel Sheet using Excel Services in SharePoint 2013.

Create Excel Sheet with Graph

Create a new excel sheet, fill some data & insert a graph as shown below.

image

Upload to SharePoint Library

Now you can upload the above file to a SharePoint Library.

image

Trusted File Locations

Ensure you have added the library path to the Trusted File Locations.  You need to open Central Administration > Service Applications > Excel Service Application > Trusted File Locations for this.

image

Create a new item with http:// as the starting address and check the Children Trusted column.  This will make sure all URLs with given starting address are trusted.  

image

Open File

Back in SharePoint user interface; open the Excel File using context menu.

image

You can see the excel file get opened in the browser.

image

This concludes our simple experiment with Excel Services.

image

The http:// string as trusted entry is not recommended for production scenarios.

References

http://technet.microsoft.com/en-us/library/jj219698%28v=office.15%29.aspx

Summary

In this article we can explore how to display an Excel Sheet using Excel Services in SharePoint 2013.

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