Services de calcul Excel : opérations Stsadm (Office SharePoint Server)
Excel Calculation Services is one of the three components of Excel Services. The role of Excel Calculation Services is to load workbooks, calculate them, call custom code (user-defined functions) and refresh external data. It also maintains the session state for interactivity. Excel Calculation Services maintains a session for the duration of interactions with the same workbook by a user or caller. A session is closed when the caller explicitly closes it or when the session times out on the server.
For additional information about the Excel Services architecture, see Excel Services Architecture (https://go.microsoft.com/fwlink/?LinkId=109271&clcid=0x409).
You can use the Stsadm command-line tool to configure Excel Calculation Services to centrally manage user access to SharePoint document libraries, UNC paths, HTTP Web sites and external databases, as well as configure the Excel Calculation Services use of system resources.
The following table describes the Excel Calculation Services operations.
| Operation name | Description |
|---|---|
Add-ecsfiletrustedlocation : opération Stsadm (Office SharePoint Server) |
Lets an administrator add a file to the trusted location list. |
Add-ecssafedataprovider : opération Stsadm (Office SharePoint Server) |
Lets an administrator add a supported provider type to the safe provider list. |
Add-ecstrusteddataconnectionlibrary : opération Stsadm (Office SharePoint Server) |
Adds a trusted data connection to a library. |
Add-ecsuserdefinedfunction : opération Stsadm (Office SharePoint Server) |
Adds a user defined function. |
Remove-ecsfiletrustedlocation : opération Stsadm (Office SharePoint Server) |
Lets an administrator remove a file from the trusted location list. |
Remove-ecssafedataprovider : opération Stsadm (Office SharePoint Server) |
Lets an administrator remove a supported provider type to the safe provider list. |
Remove-ecstrusteddataconnectionlibrary : opération Stsadm (Office SharePoint Server) |
Removes a trusted data connection from a library. |
Remove-ecsuserdefinedfunction : opération Stsadm (Office SharePoint Server) |
Removes a user-defined function from Excel Calculation Services. |
Set-ecsexternaldata : opération Stsadm (Office SharePoint Server) |
Lets an administrator set an external data connection to Excel Calculation Services. |
Set-ecsloadbalancing: opération Stsadm (Office SharePoint Server) |
Lets an administrator define load balancing for Excel Calculation Services. |
Set-ecsmemoryutilization : opération Stsadm (Office SharePoint Server) |
Lets an administrator determine memory allocation for Excel Calculation Services. |
Set-ecssecurity : opération Stsadm (Office SharePoint Server) |
Lets an administrator set security settings for Excel Calculation Services. |
Set-ecssessionmanagement : opération Stsadm (Office SharePoint Server) |
Lets an administrator set session management settings for Excel Calculation Services. |
Set-ecsworkbookcache : opération Stsadm (Office SharePoint Server) |
Lets an administrator set workbook cache settings on disk and in memory for Excel Calculation Services. |