06 September, 2012

Role of Excel Services in SharePoint 2010

Excel Services is part of Microsoft SharePoint Server 2010
Excel Services is built on ASP.NET and SharePoint Foundation technologies
Excel Services enables you to load, calculate, and display Microsoft Excel workbooks on Microsoft SharePoint Server
Core Components are:-
·         Excel Web Access
·         Excel Web Services
·         User-defined functions (UDFs)
·         ECMAScript (JavaScript, JScript)
·         Representational State Transfer (REST) service
·         Excel Calculation Services
An important aspect of Excel Services is that solution developers can use its power programmatically from their applications.
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

It supports sharing, securing, managing, and using Excel 2010 workbooks in a browser by providing the following:
Global settings for managing workbooks,
·         settings for security
·         load balancing
·         session management
·         memory utilization
·         workbook caches,
·         external data connections
·         Trusted file locations
An extensive list of trusted data providers for connecting to your data, plus the ability to add your own trusted data provider.
·         Trusted data connection libraries, which allow you to define which data connection libraries in your farm are trusted by Excel Services
·         The ability to add your own user-defined function assemblies.

2 comments:

  1. Hey! That is really nice blog. You have done a great job keep on working and share more information with us.Thanks
    pakistan web development company
    web development services pakistan
    web design company pakistan
    best web solution company

    ReplyDelete
    Replies
    1. Thank you very much for your kind words :)will try my best to contribute more and more...

      Delete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.