Add-ecsuserdefinedfunction: Stsadm operation (Office SharePoint Server)

  • Article

Applies To: Office SharePoint Server 2007

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Operation name: Add-ecsuserdefinedfunction

Description

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

Syntax

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\>\]**

Parameters

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.

See Also

Concepts

Enable user-defined functions
Remove-ecsuserdefinedfunction

Other Resources

Understanding Excel Services UDFs