Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Add-ecsuserdefinedfunction: Stsadm operation (Office SharePoint Server)

SharePoint 2007

Applies To: Office SharePoint Server 2007

Operation name: Add-ecsuserdefinedfunction

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.