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.
$udfReference = Get-SPExcelUserDefinedFunction
-ExcelServiceApplication "Excel Services Application"
-Identity "Microsoft.Office.Server.WebAnalytics.UI, Version=15.0.0.0,
Culture=neutral, PublicKeyToken=71e9bce111e9429c"
Tip
When you are creating a new user-defined function reference, the Identity
becomes the same value as the Assembly
property.
18.117.216.229