Modify Excel Services Objects

Scenario/Problem: You need to modify properties of various Excel Services objects.

Solution: Use the cmdlets listed in this section to change the configuration of existing trusted file locations, trusted data connection libraries, safe data providers, blocked file types, user-defined function references, and the Excel Services application itself.

This chapter covers the basic or more common cmdlets for creating and using Excel Services objects. For more advanced scripting and modifications of these objects, the following cmdlets are available:

Set-SPExcelServiceApplication

Set-SPExcelDataConnectionLibrary

Set-SPExcelDataProvider

Set-SPExcelFileLocation

Set-SPExcelUserDefinedFunction

Get PowerShell™ for SharePoint® 2013 How-To now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.