PowerShell™ for SharePoint® 2013 How-To

Get a Specific User-Defined Function Reference

Scenario/Problem: You need to obtain a specific user-defined function reference.

Solution: Use the Get-SPExcelUserDefinedFunction cmdlet to assign a variable the results using the -Identity and -ExcelServiceApplication parameters.

Providing the identity of the user-defined function to the Get-SPExcelUserDefinedFunction cmdlet retrieves a specific user-defined function instance. Use this to assign the results to a variable for use in other cmdlets, as shown in Listing 21.19.

Listing 21.19. Assigning a Variable to a Specific User-Defined Function

$udfReference = Get-SPExcelUserDefinedFunction-ExcelServiceApplication "Excel Services Application"-Identity "Microsoft.Office.Server.WebAnalytics.UI, ...