.png)
Excel Services cmdlets in SharePoint Server 2013
Published: July 16, 2012
Summary: Lists Windows PowerShell cmdlets that help you manage Excel Services applications in SharePoint Server 2013.
Applies to: SharePoint Server 2013 Enterprise
Excel Services Application is a service application in SharePoint Server 2013 that you can use to share, secure, and manage Excel 2013 workbooks (.xlsx, .xlsb, and .xlsm extensions) as interactive reports in a consistent way throughout the enterprise.
All Excel Services Application settings will support backup and recovery regardless of whether there is a UI setting in the SharePoint Central Administration website. This means that all global settings, trusted locations, user-defined-functions, data connection libraries, and trusted data provider settings will support backup and recovery. However, the following items will not be backed up as part of the backup and recovery process:
-
User-defined function assemblies. These assemblies will not be backed up or restored because they are binary files and not simply settings; however, the data in the list of trusted user-defined functions is backed up.
-
Trusted data provider binaries. The full list of trusted data providers and all associated properties, however, are backed up.
-
Any Excel Web Access (EWA) Web Part properties.
-
Office data connection (.odc extension) files and workbook files.
 Note: |
|---|
| URLs of any kind (that is, URLs to trusted locations, user-defined functions, or data connection libraries) must be manually fixed after a restore operation because they might no longer be valid. |
In addition to using Windows PowerShell for Excel Services Application backup and recovery functionality, you can use Windows PowerShell to provision the service application from scratch or provision a new instance that uses settings from a previous backup, and manage and configure trusted file locations, data providers, data connection libraries, and settings for user-defined function assemblies. You can also change global settings for Excel Services Application.
Index of Windows PowerShell cmdlets for SharePoint 2013 includes a complete list of all cmdlets in SharePoint 2013.
| Cmdlet Name | Description |
| Returns a file type or list of file types that are prevented from being loaded. | |
| Returns a trusted data connection library or a list of trusted data connection libraries. | |
| Returns a safe data provider or a list of safe data providers. | |
| Returns a trusted file location or a list of trusted file locations. | |
| Returns an SPExcelServiceApplication object. | |
| Returns a user-defined function or a collection of user-defined functions. | |
| Adds a file type to the list of file types that Excel Services Application prevents from being loaded. | |
| Adds a new data connection library to Excel Services Application. | |
| Adds a new safe data provider to Excel Services Application. | |
| Adds a new trusted location to Excel Services Application. | |
| Creates a new instance of Excel Services Application. | |
| Adds a new user-defined function to Excel Services Application. | |
| Removes an entry from the list of file types that are prevented from being loaded on Excel Services Application. | |
| Removes a data connection library from Excel Services Application. | |
| Removes a data provider from Excel Services Application. | |
| Removes a trusted file location from Excel Services Application. | |
| Removes a user-defined function from Excel Services Application. | |
| Sets properties of a data connection library for Excel Services Application. | |
| Sets properties of a safe data provider for Excel Services Application. | |
| Sets properties of a trusted file location for Excel Services Application. | |
| Sets global properties for Excel Services Application. | |
| Sets properties of a user-defined function in Excel Services Application. |
Change History
| Date | Description |
|---|---|
| July 16, 2012 | Initial publication |
