Manage Excel Services custom applications (SharePoint Server 2010)

  • Article

 

Applies to: SharePoint Server 2010, Excel Services (SharePoint 2010)

Excel Services in Microsoft SharePoint Server 2010 provides several ways to extend the capabilities of Excel Calculation Services, customize applications and workbooks, and also allow developers to incorporated Excel Services into their solutions. These are as follows:

  • User-defined functions

  • ECMAScript

  • REST API

User-defined functions

If your deployment scenarios include workbooks that contain user-defined functions to extend the capabilities of Excel Calculation Services, you have to configure Excel Services to support user-defined functions. To configure support for user-defined functions, you must enable user-defined functions on trusted file locations that contain workbooks that require access to user-defined functions. In addition, you must register user-defined function assemblies on the Excel Services user-defined function assembly list.

This section includes procedures for managing user-defined functions in Excel Services. For additional information about user-defined functions, see Excel Services User-Defined Functions.

To enable user-defined functions on a trusted file location

  1. On the SharePoint Central Administration home page, in the Application Management section, click Manage service applications.

  2. On the Manage Service Applications page, click the Excel Services service application that you want to manage.

  3. On the Manage Excel Services page, click Trusted File Locations.

  4. On the Trusted File Locations page, click the trusted file location for which you want to enable user-defined functions.

  5. On the Edit Trusted File Location page, in the User-Defined Functions section, select the User-defined functions allowed check box.

  6. Click OK.

To manage Excel Services user-defined function assemblies

  1. On the Central Administration home page, in the Application Management section, click Manage service applications.

  2. On the Manage Service Applications page, click the Excel Services service application that you want to manage.

  3. On the Manage Excel Services page, click User Defined Function Assemblies.

To add a user-defined function assembly

  1. On the Excel Services User Defined Functions page, click Add User-Defined Function Assembly.

  2. On the Add User-Defined Function Assembly page, in the Assembly section, type the assembly name or the full path of an assembly that contains the user-defined functions, which you want to call in the Assembly box.

  3. Under Assembly Location, select one of the following:

    • Global assembly cache (a global place where signed assemblies can be deployed and run with full trust by default)

    • File path (a local or network file location)

  4. In the Enable Assembly section, select the Assembly enabled check box to enable Excel Calculation Services to call the assembly. You can clear the check box to disable the assembly without removing the function assembly from the list.

  5. In the Description box, you may choose to type a description of the purpose for the function assembly.

  6. Click OK.

To edit a user-defined function assembly

  1. On the Excel Services User Defined Functions page, point to the user-defined function assembly that you want to edit, click the arrow that appears, and then click Edit.

To delete a user-defined function assembly

  1. On the Excel Services User Defined Functions page, point to the user-defined function assembly that you want to delete, click the arrow that appears, and then click Delete.

  2. Click OK in the message box that asks whether you want to proceed with the deletion.

ECMAScript

The Excel Services ECMAScript or JavaScript Object Model is an Object Model implemented in and for use by JavaScript.

The Excel Services ECMAScript Object Model enables syndication, mash-ups/composite applications, automation of Excel Services, encapsulation of user events, and the extension of Excel Services by third parties. For a complete list of all objects, methods, and events used in the Excel Services ECMAScript Object Model, see Excel Services ECMAScript (JavaScript, JScript).

Embedding ECMA scripts in Web pages is often done with Excel Services.

REST API

A REST API for Excel Services enables operations against Microsoft Excel workbooks using GET operations. This allows for a flexible and simple mechanism to access and manipulate Excel Services content and data. For more information, see Excel Services REST API.