PowerShell™ for SharePoint® 2013 How-To

Get a Specific Trusted File Location

Scenario/Problem: You need to obtain a specific trusted file location reference.

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

Providing the identity of the trusted file location to the Get-SPExcelFileLocation cmdlet retrieves a specific trusted file location instance. Use this to assign the results to a variable for use in other cmdlets, as shown in Listing 21.3.

Listing 21.3. Assigning a Variable to a Specific Trusted File Location

$trustedLocation = Get-SPExcelFileLocation-Identity "http://sp2010/Excel Workbooks"-ExcelServiceApplication "Excel Services Application"

Tip

When you are creating a new trusted ...