Étape 3 : déploiement et activation des fonctions définies par l'utilisateur (UDF)

  • Article

In this step, you will:

  1. Deploy SampleUdf.dll, which you created in Step 2: Creating a Managed-Code UDF, to a folder on a computer that has Microsoft SharePoint Server 2010 installed.

  2. Allow user-defined functions (UDFs) to be called from a specific trusted location, for example, trusted Shared Documents location.

  3. Activer SampleUdf.dll.

Déploiement des fonctions définies par l'utilisateur

Pour déployer des fonctions définies par l'utilisateur

  1. Create a folder named "UDFs" on the local drive of the computer to which you want to deploy UDFs. For example, "C:\UDFs".

  2. Copy the SampleUdf.dll assembly.

  3. Save SampleUdf.dll in "C:\UDFs".

Approbation d'un emplacement

Pour approuver un emplacement

  1. On the Start menu, click All Programs.

  2. Point to Microsoft SharePoint 2010 Products and click SharePoint Central Administration.

  3. Under Application Management click Manage service applications.

  4. On the Manage Service Applications page, click Excel Services Application.

  5. On the Excel Services Application page, click Trusted File Locations.

  6. On the Trusted File Locations page, click Add Trusted File Location.

  7. On the Add Trusted File Location page, in the Address box, type the location where you will save your workbook—for example, http://MyServer002/Shared%20Documents.

  8. Under Location type, click the appropriate location type. In this example, select Microsoft SharePoint Foundation.

  9. Under Trust Children, select Children trusted to trust child libraries or directories.

  10. Under Allow User-Defined Functions, select User-defined functions allowed to allow UDFs to be called from workbooks stored in this trusted location.

  11. Cliquez sur OK.

Activation des fonctions définies par l'utilisateur

To do the following steps, you need a computer that has SharePoint Server 2010 installed.

Pour activer les fonctions définies par l'utilisateur

  1. Suivez les étapes 1 à 3 de la procédure précédente (« Pour approuver un emplacement ») pour afficher la page d'accueil Services Partagés d'un fournisseur de services partagés.

  2. Under Excel Services Settings, click User-defined function assemblies.

  3. Dans la page Excel Services des fonctions définies par l'utilisateur, cliquez sur Ajouter une fonction définie par l'utilisateur pour ouvrir la page ExcelServices Ajouter un assembly de fonction définie par l'utilisateur.

  4. In the Assembly box, type the path to the SampleUdf.dll assembly. In this example, it would be C:\UDFs\SampleUdf.dll.

  5. Under Assembly Location, click File path.

  6. Under Enable Assembly, the Assembly enabled check box should be selected by default.

  7. Cliquez sur OK.

Programmation robuste

If the AllowUdfs value is false when a session is started on a workbook that has UDF calls, the UDF calls will fail.

Notes

[!REMARQUE] The AllowUdfs flag is denoted by the User-defined functions allowed option (see step 9 in the "Trusting a Location" section).

If you change the AllowUdfs value to true after a session has started, the UDF calls will also fail. This is because changes in the AllowUdfs flag take effect on the next session. You can get around this by resetting Microsoft Internet Information Services (IIS). Resetting IIS will reload UDFs.

For more information about resetting IIS, see How to: Enable UDFs.

Voir aussi