Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Administration of Excel Services
The ExcelServerUserDefinedFunctions.aspx page is displayed (see Figure 7-20). Use this page to add a
UDF assembly, edit an existing UDF assembly, delete an existing UDF assembly, or simply see the
properties for existing UDF assemblies.
To edit or delete an existing UDF assembly, open the ECB menu associated with the corresponding UDF
assembly entry in the list, and select the operation you want to perform. To create a new UDF assembly,
use the Add User-Defined Function Assembly link at the top of the UDF assembly list.
As shown in Figure 7-21, the Assembly Details section of the page contains the following settings for the
User-Defined Function Assembly properties:
Assembly — Either the strong name or the full path for the managed UDF assembly. This
location determines how you reference the assembly. If the assembly is in the Global Assembly
Cache (GAC), provide the strong name for your assembly. Otherwise, provide the full path,
which must include the name of the assembly. For example:
Strong name — Company.Department.TeamUdf
File path — E:\Udfs\TeamUdf.dll or \\TheServer\TheShare\Udfs\TeamUdf.dll
Assembly Location — Identifies the location type for the assembly. You have two options for this
Global Assembly Cache — This is the default, .NET Global Assembly Cache.
File Path — This is the local or UNC path.