Поделиться через

Manage Excel Services custom applications (SharePoint Server 2010)

  • Статья

 

Применимо к: Excel Services (SharePoint 2010), SharePoint Server 2010

Последнее изменение раздела: 2016-11-30

Excel в Microsoft SharePoint Server 2010 provides several ways to extend the capabilities of Службы вычислений Excel, customize applications and workbooks, and also allow developers to incorporated Службы Excel 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, you have to configure Службы Excel 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 user-defined function assembly list.

This section includes procedures for managing user-defined functions in Службы Excel. 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 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 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 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 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 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 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 ECMAScript or JavaScript Object Model is an Object Model implemented in and for use by JavaScript.

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

Embedding ECMA scripts in Web pages is often done with Службы Excel.

REST API

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