Home > PowerShell, SharePoint 2010 > Excel Services cmdlets (SharePoint Server 2010)

Excel Services cmdlets (SharePoint Server 2010)

Updated: 2009-12-14

[This article is pre-release documentation and is subject to change in future releases.]

Excel Services Application is a service application in Microsoft SharePoint Server 2010 that you can use to share, secure, and manage Microsoft Excel 2010 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 Central Administration Web site. 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.

Ee906545.note(en-us,office.14).gifNote:

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

The following cmdlets are available for Beta.

Cmdlet Name

Get-SPExcelBlockedFileType

New-SPExcelBlockedFileType

Remove-SPExcelBlockedFileType

Get-SPExcelDataConnectionLibrary

New-SPExcelDataConnectionLibrary

Remove-SPExcelDataConnectionLibrary

Set-SPExcelDataConnectionLibrary

Get-SPExcelDataProvider

New-SPExcelDataProvider

Remove-SPExcelDataProvider

Set-SPExcelDataProvider

Get-SPExcelFileLocation

New-SPExcelFileLocation

Remove-SPExcelFileLocation

Set-SPExcelFileLocation

Get-SPExcelServiceApplication

New-SPExcelServiceApplication

Set-SPExcelServiceApplication

Get-SPExcelUserDefinedFunction

New-SPExcelUserDefinedFunction

Remove-SPExcelUserDefinedFunction

Set-SPExcelUserDefinedFunction

To download the ExcelServicesApplicationCmdlets.chm file, see Windows PowerShell for SharePoint Server 2010 Beta (http://go.microsoft.com/fwlink/?LinkId=179124).

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: