Remove-SPExcelBlockedFileType

從檔案類型清單中移除專案,這些檔案類型無法在 Excel Services 應用程式上載入。

Syntax

Remove-SPExcelBlockedFileType
      [-Identity] <SPExcelBlockedFileTypePipeBind>
      -ExcelServiceApplication <SPExcelServiceApplicationPipeBind>
      [-AssignmentCollection <SPAssignmentCollection>]
      [-Confirm]
      [-WhatIf]
      [<CommonParameters>]

Description

Cmdlet Remove-SPExcelBlockedExcelFileType 會從檔案類型清單中移除專案,這些檔案類型無法在Excel Services應用程式 Web 服務應用程式上載入。 Excel Services應用程式不會載入對應至此清單上檔案類型的任何檔案類型。

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

範例

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

Get-SPExcelServiceApplication -Identity "MyExcelService" | Remove-SPExcelBlockedExcelFileType -FileType XLSX

本範例會從Excel Services應用程式無法載入的檔案類型清單中移除.xlsx副檔名。

從清單中移除.xlsx副檔名之後,允許在 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

指定包含 SPBlockedExcelFileType 清單物件的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;下列其中一種檔案類型:XLSX、XLSB、XLSM;或有效 SPExcelBlockedFileType 物件的實例。

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