Remove-SPExcelDataConnectionLibrary

從 Excel Services 應用程式移除資料連線庫。

Syntax

Remove-SPExcelDataConnectionLibrary
      [-Identity] <SPExcelDCLPipeBind>
      -ExcelServiceApplication <SPExcelServiceApplicationPipeBind>
      [-AssignmentCollection <SPAssignmentCollection>]
      [-Confirm]
      [-WhatIf]
      [<CommonParameters>]

Description

Cmdlet Remove-SPExcelDataConnectionLibrary 會從 [Excel Services應用程式信任的資料連線程式庫清單中移除程式庫。 Excel Services應用程式只有在資料連線檔案儲存在信任的資料連線程式庫清單上時,才會載入資料連線檔案。

如需適用於 SharePoint 產品的 Windows PowerShell 權限及最新資訊,請參閱線上文件 SharePoint Server Cmdlet

範例

-----------------------範例-----------------------------

Get-SPExcelServiceApplication | Get-SPExcelDataConnectionLibrary | Remove-SPExcelDataConnectionLibrary

本範例會從伺服器陣列中執行的所有Excel Services應用程式中移除所有資料連線程式庫。

不會再從任何程式庫載入連線檔案。 依存任何連線檔案的活頁簿可能都無法重新整理資料。

參數

-AssignmentCollection

Manages objects for the purpose of proper disposal. Use of objects, such as SPWeb or SPSite, can use large amounts of memory and use of these objects in Windows PowerShell scripts requires proper memory management. Using the SPAssignment object, you can assign objects to a variable and dispose of the objects after they are needed to free up memory. When SPWeb, SPSite, or SPSiteAdministration objects are used, the objects are automatically disposed of if an assignment collection or the Global parameter is not used.

When the Global parameter is used, all objects are contained in the global store. If objects are not immediately used, or disposed of by using the Stop-SPAssignment command, an out-of-memory scenario can occur.

Type:SPAssignmentCollection
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013

-Confirm

Prompts you for confirmation before executing the command. For more information, type the following command: get-help about_commonparameters

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013

-ExcelServiceApplication

指定包含 SPExcelDataConnectionLibrary 清單物件的Excel Services應用程式 Web 服務應用程式。

其類型必須為有效的 GUID,且格式為 12345678-90ab-cdef-1234-567890bcdefgh;在伺服器陣列 (例如,MyExcelService1) 中,Excel Services 應用程式 Web 服務應用程式的有效名稱;或是有效之 SPExcelServiceApplication 物件的執行個體。

Type:SPExcelServiceApplicationPipeBind
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013

-Identity

這會指定要移除的資料連線庫。

此類型必須是格式為 12345678-90ab-cdef-1234-567890bcdefgh 的有效 GUID;資料連線程式庫的有效名稱, (例如 DataConnectionLib1) ;格式為 的有效 URL https://server_name ,或有效 SPExcelDCL 物件的實例。

Type:SPExcelDCLPipeBind
Position:1
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013

-WhatIf

Displays a message that describes the effect of the command instead of executing the command. For more information, type the following command: get-help about_commonparameters

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013