SharePoint Excel Service-PowerShell
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