Remove-SPExcelDataProvider

從 Excel Services 應用程式移除資料提供者。

Syntax

Remove-SPExcelDataProvider
      [-Identity] <SPExcelDataProviderPipeBind>
      [-AssignmentCollection <SPAssignmentCollection>]
      [-Confirm]
      [-WhatIf]
      [<CommonParameters>]

Description

Cmdlet Remove-SPExcelDataProvider 會移除儲存在安全資料提供者清單上的資料提供者。 Excel Services只有在該連接的資料提供者位於安全資料提供者清單時,應用程式才會重新整理外部資料連線。 Excel Services應用程式包含此清單上的一組通用資料提供者,因此使用 Cmdlet 修改安全資料提供者通常只會在自訂資料連線案例中完成。

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

範例

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

C:\PS>$provider = Get-SPExcelServiceApplication -Identity "MyExcelService" | Get-SPExcelDataProvider | { where {$_.providerID -eq "MyCustomProvider"}

Remove-SPExcelDataProvider $provider

本範例會從名為 MyExcelService 的Excel Services應用程式 Web 服務應用程式上的安全資料提供者清單中移除自訂資料提供者。

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

-Identity

這會指定要移除的 SPExcelDataProvider 物件。

其類型必須為有效的 GUID,且格式為 12345678-90ab-cdef-1234-567890bcdefgh,或是有效之 SPExcelDataProvider 物件的執行個體。

Type:SPExcelDataProviderPipeBind
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