1. 创建一个信任的文件路径
New-SPExcelFileLocation -Address "http://sp2010/Excel Workbooks"
-ExcelServiceApplication "Excel Services Application"
–LocationType SharePoint -IncludeChildren
2. 显示所有信任的文件路径
Get-SPExcelFileLocation
–ExcelServiceApplication "Excel Services Application"
3. 获取指定信任的文件路径
$trustedLocation = Get-SPExcelFileLocation
-Identity "http://sp2010/Excel Workbooks"
–ExcelServiceApplication "Excel Services Application"
4. 移除一个信任的文件路径
$trustedLocation = Get-SPExcelFileLocation -Identity "http://sp2010/Excel Workbooks" –ExcelServiceApplication "Excel Services Application"
Remove-SPExcelFileLocation $trustedLocation
–ExcelServiceApplication "Excel Service Application"
5. 创建一个信任的数据连接库
New-SPExcelDataConnectionLibrary
-Address "http://sp2010/Data Connections"
-ExcelServiceApplication "Excel Services Application"
6. 显示所有信任的数据连接库
Get-SPExcelDataConnectionLibrary
–ExcelServiceApplication "Excel Services Application"
7. 获取指定信任的数据连接库
$trustedLibrary = Get-SPExcelDataConnectionLibrary
-Identity "http://sp2010/Data Connections"
–ExcelServiceApplication "Excel Services Application"
8. 移除一个信任的数据连接库
$trustedLibrary = Get-SPExcelDataConnectionLibrary
-Identity "http://sp2010/Data Connections"
–ExcelServiceApplication "Excel Services Application"
Remove-SPExcelDataConnectionLibrary $trustedLibrary
–ExcelServiceApplication "Excel Service Application"
9. 创建一个安全数据提供程序
New-SPExcelDataProvider
-ExcelServiceApplication "Excel Services Application"
–ProviderID "Custom DB" –ProviderType ODBC
10. 显示所有安全数据提供程序
Get-SPExcelDataProvider
–ExcelServiceApplication "Excel Services Application"
11. 获取指定的安全数据提供程序
$dataProvider = Get-SPExcelServiceApplication
-Identity "Excel Services Application" | Get-SPExcelDataProvider
| where {$_.ProviderID -eq "Custom DB"}
12. 移除一个安全数据提供程序
$dataProvider = Get-SPExcelServiceApplication
-Identity "Excel Services Application" | Get-SPExcelDataProvider
| where {$_.ProviderID -eq "Custom DB"}
Remove-SPExcelDataProvider $dataProvider
13. 添加一个阻止的文件类型
New-SPExcelBlockedFileType
-ExcelServiceApplication "Excel Services Application" –FileType XLSB
14. 显示所有阻止的文件类型
Get-SPExcelBlockedFileType
–ExcelServiceApplication "Excel Services Application"
15. 获取指定阻止的文件类型
$blockedFileType = Get-SPExcelBlockedFileType
-Identity "XLSB" –ExcelServiceApplication "Excel Services Application"
16. 移除一个阻止的文件类型
$blockedFileType = Get-SPExcelBlockedFileType -Identity "XLSB"
–ExcelServiceApplication "Excel Services Application"
Remove-SPExcelBlockedFileType $blockedFileType
–ExcelServiceApplication "Excel Service Application"
17. 创建一个用户定义函数引用
New-SPExcelUserDefinedFunction -ExcelServiceApplication "Excel Services Application" –Assembly "MyCompany.ExcelServices.UDF,
Version=1.0.0.0, Culture=neutral, PublicKeyToken=82e6dce111e9429c"
–AssemblyLocation GAC
18. 显示所有用户定义函数引用
Get-SPExcelUserDefinedFunction
–ExcelServiceApplication "Excel Services Application"
19. 获取指定的用户定义函数引用
$udfReference = Get-SPExcelUserDefinedFunction
–ExcelServiceApplication "Excel Services Application"
-Identity "Microsoft.Office.Server.WebAnalytics.UI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
20. 移除一个用户定义函数引用
$udfReference = Get-SPExcelUserDefinedFunction
–ExcelServiceApplication "Excel Services Application"
-Identity "Microsoft.Office.Server.WebAnalytics.UI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
Remove-SPExcelUserDefinedFunction $udfReference
–ExcelServiceApplication "Excel Service Application"
21. 其他命令
Set-SPExcelServiceApplication
Set-SPExcelDataConnectionLibrary
Set-SPExcelDataProvider
Set-SPExcelFileLocation
Set-SPExcelUserDefinedFunction