Share via

Excel Services Architecture In SharePoint Server 2010

  • Article

Excel Services is part of Microsoft SharePoint Server 2010. Excel Services is built on ASP.NET and SharePoint Foundation technologies. Following are the core components in Excel Services:

  • · Excel Web Access
  • · Excel Web Services
  • · User-defined functions (UDFs)
  • · ECMAScript (JavaScript, JScript)
  • · Representational State Transfer (REST) service
  • · Excel Calculation Services

The Excel Web Access, Excel Web Services, UDFs, ECMAScript, the REST service, and Excel Calculation Services components can be divided into two major groups: the components on a front-end server (also known as the "Web front end") and the component on a back-end application server.

An important aspect of Excel Services is that solution developers can use its power programmatically from their applications. These applications can be line-of-business (LOB) products or custom enterprise solutions that an organization develops internally.

Following are examples of these applications:

  • · Multitiered applications, with the presentation layer implemented as a Web application (for example, an ASP.NET application) that calls Excel Web Services.
  • · Applications within Microsoft SharePoint Server 2010, or integrated with LOB products.

There are five types of development that you can do by using Excel Services:

  • · Develop solutions by using Excel Web Services
  • · Extend the Microsoft Excel function library in Excel Services by using user-defined functions (UDFs)
  • · Customize the Excel Web Access Web Part
  • · Develop solutions by using ECMAScript (JavaScript, JScript)
  • · Use the REST API to perform operations against Excel workbooks

For more info, see https://msdn.microsoft.com/en-us/library/ms517343.aspx

Excel Services Architecture In SharePoint Server 2010

Comments

  • Anonymous
    January 09, 2012
    That's pretty cool, and I might even find a use for it in one of the projects I'm working on.  

  • Anonymous
    January 20, 2012
    The comment has been removed

  • Anonymous
    March 16, 2012
    haha, my Excel tutoring material too complicated and this chart is easy for me to understand. Entry from: http://www.borsefirmate.co

  • Anonymous
    September 05, 2013
    From this diagram, you can see that Excel Services via SharePoint (2010 or higher) is easily as powerful as any middleware offering, and Excel's ease of use lends it to being easily integrated into a number of financial, statistical and other apps.