Remove-SPExcelUserDefinedFunction

从 Excel Services 应用程序中删除用户定义的函数。

语法

Remove-SPExcelUserDefinedFunction
      [-Identity] <SPExcelUDFPipeBind>
      -ExcelServiceApplication <SPExcelServiceApplicationPipeBind>
      [-AssignmentCollection <SPAssignmentCollection>]
      [-Confirm]
      [-WhatIf]
      [<CommonParameters>]

说明

Remove-SPExcelUserDefinedFunction cmdlet 从用户定义函数列表中删除用户定义的函数。 用户定义的函数是托管代码程序集,可以使用标准Excel Services应用程序公式语法从Excel Services应用程序工作簿调用这些程序集。 这些程序集可以执行自定义逻辑或其他操作,如刷新数据。 Windows PowerShell cmdlet 对用户定义函数列表中的条目执行操作,而不对程序集执行操作。

有关适用于 SharePoint 产品的 Windows PowerShell 的权限和最新信息,请参阅 SharePoint Server cmdlet

示例

-----------------------示例-----------------------------

Get-SPExcelServiceApplication | Remove-SPExcelUserDefinedFunction -Identity "SampleCompany.SampleApplication.SampleUdf"

本示例从场中每个Excel Services应用程序 Web 服务应用程序的用户定义函数列表中删除 SampleCompany.SampleApplication.SampleUdf 用户定义函数。

参数

-Confirm

Prompts you for confirmation before executing the command. For more information, type the following command: get-help about_commonparameters

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013

-ExcelServiceApplication

指定包含用户定义函数列表的Excel Services应用程序 Web 服务应用程序。

该类型必须是有效的 GUID,格式为 12345678-90ab-cdef-1234-567890bcdefgh;场中Excel Services应用程序 Web 服务应用程序的有效名称 (例如 MyExcelService1) ;或有效的 SPExcelServiceApplication 对象的实例。

Type:SPExcelServiceApplicationPipeBind
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013

-Identity

指定要删除的 SPExcelUserDefinedFunction 对象。

键入的值必须为代码程序集的有效名称(如 SampleCompany.SampleApplication.SampleUdf);或有效 SPExcelUDF 对象的实例。

Type:SPExcelUDFPipeBind
Position:1
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013

-WhatIf

Displays a message that describes the effect of the command instead of executing the command. For more information, type the following command: get-help about_commonparameters

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013

-工作分配

Manages objects for the purpose of proper disposal. Use of objects, such as SPWeb or SPSite, can use large amounts of memory and use of these objects in Windows PowerShell scripts requires proper memory management. Using the SPAssignment object, you can assign objects to a variable and dispose of the objects after they are needed to free up memory. When SPWeb, SPSite, or SPSiteAdministration objects are used, the objects are automatically disposed of if an assignment collection or the Global parameter is not used.

When the Global parameter is used, all objects are contained in the global store. If objects are not immediately used, or disposed of by using the Stop-SPAssignment command, an out-of-memory scenario can occur.

Type:SPAssignmentCollection
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013