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
分享到:
相关推荐
1 Key Deploy SharePoint Solutions
节点-PowerShell Node-PowerShell利用当今技术世界中存在的两个最简单,有效和简便的工具。 一方面, 在javascript领域掀起了一场革命,另一方面, 最近推出了最初的开源,跨平台版本,并将它们连接在一起,使您能够...
The Command Line Crash Course--- PowerShell速成教程,国外网站上收集整理,方便阅读
Bohannon-Revoke-Obfuscation-PowerShell-Obfuscation-Detection-And Evasion-Using-Science-wp
us-17-Bohannon-Revoke-Obfuscation-PowerShell-Obfuscation-Detection-And Evasion-Using-Science-wp
us-17-Dods-Infecting-The-Enterprise-Abusing-Office365-Powershell-For-Covert-C2
WindowsServer2003-KB926140-v5-x86-CHS-powershell
藏经阁-Infecting-The-Enterprise-Abusing-Office365-Powershell-For-Covert-C2
Dods-Infecting-The-Enterprise-Abusing-Office365-Powershell-For-Covert-C2
Tableau-Powershell-Scripts-master.rar
该解决方案包含一个PowerShell命令库,该命令库使您可以对SharePoint执行复杂的配置和工件管理操作。 这些命令在后台使用CSOM和REST的组合,并且可以与SharePoint Online一起作为SharePoint内部部署。 我发现了一个...
vscode-powershell, 为 Visual Studio 代码提供PowerShell语言和调试支持 用于 Visual Studio 代码的语言支持 这里扩展为 Visual Studio 代码提供了丰富的PowerShell语言支持。 现在你可以使用 Visual Studio 代码...
PowerShell重启服务(Restart-Service),使用PowerShell可以很方便的操作Windows系统服务,比如实现自动重启服务。本文就介绍如何使用PowerShell来重启服务,以及一些相关的内容。PowerShell中重启服务的cmdlet是...
AspNetCore.Health使负载平衡器能够监视已部署的Web应用程序的状态 -C#-PowerShell-下载
2020.04-远控免杀从入门到实践(6)-代码篇-Powershell1
Managing SharePoint workflow association using PowerShell 60 Configuring site themes and user interface artifacts 65 Chapter 3: Performing Advanced List and Content Operations in SharePoint using ...
awesome-powershell:令人愉悦的PowerShell模块和资源的精选列表
主要介绍了python通过ssh-powershell监控windows的方法,涉及Python操作ssh-powershell的相关技巧,需要的朋友可以参考下
PowerShell Import-Excel- 从安装。 通过此PowerShell模块,您可以读写Excel文件,而无需在系统上安装Microsoft Excel。 无需打扰繁琐的Excel COM对象。 创建表格,数据透视表,图表等等变得更加容易。 影片教学 ...