Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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 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

Get-SPExcelBlockedFileType

Returns a file type or list of file types that are prevented from being loaded.

Get-SPExcelDataConnectionLibrary

Returns a trusted data connection library or a list of trusted data connection libraries.

Get-SPExcelDataProvider

Returns a safe data provider or a list of safe data providers.

Get-SPExcelFileLocation

Returns a trusted file location or a list of trusted file locations.

Get-SPExcelServiceApplication

Returns an SPExcelServiceApplication object.

Get-SPExcelUserDefinedFunction

Returns a user-defined function or a collection of user-defined functions.

New-SPExcelBlockedFileType

Adds a file type to the list of file types that Excel Services Application prevents from being loaded.

New-SPExcelDataConnectionLibrary

Adds a new data connection library to Excel Services Application.

New-SPExcelDataProvider

Adds a new safe data provider to Excel Services Application.

New-SPExcelFileLocation

Adds a new trusted location to Excel Services Application.

New-SPExcelServiceApplication

Creates a new instance of Excel Services Application.

New-SPExcelUserDefinedFunction

Adds a new user-defined function to Excel Services Application.

Remove-SPExcelBlockedFileType

Removes an entry from the list of file types that are prevented from being loaded on Excel Services Application.

Remove-SPExcelDataConnectionLibrary

Removes a data connection library from Excel Services Application.

Remove-SPExcelDataProvider

Removes a data provider from Excel Services Application.

Remove-SPExcelFileLocation

Removes a trusted file location from Excel Services Application.

Remove-SPExcelUserDefinedFunction

Removes a user-defined function from Excel Services Application.

Set-SPExcelDataConnectionLibrary

Sets properties of a data connection library for Excel Services Application.

Set-SPExcelDataProvider

Sets properties of a safe data provider for Excel Services Application.

Set-SPExcelFileLocation

Sets properties of a trusted file location for Excel Services Application.

Set-SPExcelServiceApplication

Sets global properties for Excel Services Application.

Set-SPExcelUserDefinedFunction

Sets properties of a user-defined function in Excel Services Application.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.