Export (0) Print
Expand All

Add-ecsuserdefinedfunction: Stsadm operation (Office SharePoint Server)

SharePoint 2007

Applies To: Office SharePoint Server 2007

 

Topic Last Modified: 2008-02-11

Adds a user-defined function, which is a custom function that extends the calculation or data-import capabilities of Microsoft Excel.

This operation is equivalent to the Excel Services User-Defined Functions user interface setting that is located on the Excel Services Settings page of the Shared Services Administration Web site.

For more information about UDFs, see Manage Excel Services user-defined functions

stsadm -o add-ecsuserdefinedfunction

   -ssp <SSP name>

   -assembly <strong assembly name or file path to an assembly>

   -assemblyLocation {GAC | File}

   [-enable {True | False}]

   [-description <descriptive text>]

 

Parameter

Value

Required?

Description

ssp

A valid SSP name, such as "SharedServices1"

Yes

The name of the SSP that provides the resources for the Excel Calculation Services you want to configure.

assembly

One of the following value types:

  • Strong assembly name, for example, Global Assembly Cache (GAC) location in the form SampleCompany.SampleApplication.SampleUdf

  • File path to an assembly, for example, \\MyNetworkServer\Udfs\SampleUdf.dll

Yes

Strong name of or full path to an assembly that contains user-defined functions, which Excel Calculation Services can call.

The maximum character length is 4096.

assemblylocation

One of the following values:

  • GAC

  • File

Yes

Specifies an assembly location.

enable

One of the following values:

  • True (Default value)

  • False

No

True: Allows the assembly to be loaded and used by Excel Calculation Services.

False: Disables the assembly without having to completely remove the entry from the list.

description

A valid string value, for example, "This is a user-defined function for calculating interest"

No

Optional description of the user-defined functions.

The maximum character length is 4096 characters.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft