Partilhar via

Manage Excel Services custom applications (SharePoint Server 2010)

  • Artigo

 

Aplica-se a: Excel Services (SharePoint 2010), SharePoint Server 2010

Tópico modificado em: 2016-11-30

Serviços do Excel no Microsoft SharePoint Server 2010 provides several ways to extend the capabilities of Serviços de Cálculo do Excel, customize applications and workbooks, and also allow developers to incorporated Serviços do 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 Serviços de Cálculo do Excel, you have to configure Serviços do 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 Serviços do Excel user-defined function assembly list.

This section includes procedures for managing user-defined functions in Serviços do 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 Serviços do 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 Serviços do 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 Serviços do 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 Serviços de Cálculo do 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 Serviços do 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 Serviços do 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 Serviços do Excel ECMAScript or JavaScript Object Model is an Object Model implemented in and for use by JavaScript.

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

Embedding ECMA scripts in Web pages is often done with Serviços do Excel.

REST API

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