管理 Excel Services 使用者定義的函數組件 (SharePoint Server 2013)Manage Excel Services user defined function assemblies (SharePoint Server 2013)

摘要:新增、 編輯或刪除 SharePoint Server 2013 中的 Excel Services 使用者定義的函數組件。Summary: Add, edit or delete Excel Services user-defined function assemblies in SharePoint Server 2013.

重要

本文中的步驟適用於 SharePoint Server 2013 Enterprise 中。The steps in this article apply to SharePoint Server 2013 Enterprise.

如果您的部署案例內含的活頁簿包含用以擴充功能的 Excel Calculation Services 使用者定義函數,您必須註冊 Excel Services 使用者定義的函數組件清單上的使用者定義的函數組件。If your deployment scenarios include workbooks that contain user-defined functions to extend the capabilities of Excel Calculation Services, you must register the user-defined function assemblies on the Excel Services user-defined function assembly list.

開始這項作業之前,請參閱下列有關先決條件的資訊:Before you begin this operation, review the following information about prerequisites:

  • 若要使用的使用者定義函數,您必須啟用包含需要的存取權的使用者定義函數的活頁簿的受信任的檔案位置上的使用者定義函數。如需設定信任的檔案位置資訊,請參閱設定信任的檔案位置To use user-defined functions, you must enable user-defined functions on trusted file locations that contain workbooks that require access to user-defined functions. For information about configuring trusted file locations, see Configure a trusted file location.

  • 您必須是伺服器陣列管理員群組或 Excel Services 服務應用程式管理員可執行本文中的程序的成員。You must be a member of the Farm Administrators group or an Excel Services service application administrator to perform the procedures in this article.

登錄使用者定義的函數組件Register a user-defined function assembly

使用下列程序登錄與 Excel Services 使用之使用者定義的函數組件。Use the following procedure to register a user-defined function assembly for use with Excel Services.

登錄使用者定義的函數組件To register a user-defined function assembly

  1. 按一下 [SharePoint 管理中心網站首頁上,在 [應用程式管理] 區段的 [管理服務應用程式]。On the SharePoint Central Administration website home page, in the Application Management section, click Manage service applications.

  2. 在 [管理服務應用程式] 頁面上,按一下您想要管理 Excel Services 服務應用程式。On the Manage Service Applications page, click the Excel Services service application that you want to manage.

  3. 在 [管理 Excel Services] 頁面上按一下 [使用者定義的函數組件]。On the Manage Excel Services page, click User Defined Function Assemblies.

  4. 在 [Excel Services 使用者定義的函數] 頁面上按一下 [新增使用者定義的函數組件]。On the Excel Services User Defined Functions page, click Add User-Defined Function Assembly.

  5. 在 [新增使用者定義的函數組件] 頁面的 [組件] 區段中,輸入組件名稱或包含使用者定義函數,您想要呼叫組件] 方塊中的組件的完整路徑。On the Add User-Defined Function Assembly page, in the Assembly section, type the assembly name or the full path of an assembly that contains the user-defined functions, which you want to call in the Assembly box.

  6. [組件位置] 下選取下列其中一項:Under Assembly Location, select one of the following:

    • 全域組件快取(預設部署及執行完全信任簽署之組件可以在其中的全域位置)Global assembly cache (a global place where signed assemblies can be deployed and run with full trust by default)

    • 檔案路徑(本機或網路檔案位置)File path (a local or network file location)

  7. 在 [啟用組件] 區段中選取 [啟用 Excel Calculation Services 呼叫組件 [組件已啟用] 核取方塊。您可以清除核取方塊停用之組件而不從清單中移除的函數組件。In the Enable Assembly section, select the Assembly enabled check box to enable Excel Calculation Services to call the assembly. You can clear the check box to disable the assembly without removing the function assembly from the list.

  8. 在 [描述] 方塊中,您可以選擇輸入函數組件用途的描述。In the Description box, you may choose to type a description of the purpose for the function assembly.

  9. 按一下 [ OK ]。Click OK.

編輯使用者定義的函數組件詳細資料Edit user-defined function assembly details

使用下列程序編輯已登錄使用者定義的函數組件之使用者定義的函數組件詳細資料。您也可以使用此程序停用組件。Use the following procedure to edit the user-defined function assembly details for a registered user-defined function assembly. You can also use this procedure to disable the assembly.

若要編輯使用者定義的函數組件詳細資料To edit user-defined function assembly details

  1. 在管理中心首頁上,按一下 [應用程式管理] 區段中的 [管理服務應用程式]。On the Central Administration home page, in the Application Management section, click Manage service applications.

  2. 在 [管理服務應用程式] 頁面上,按一下您想要管理 Excel Services 服務應用程式。On the Manage Service Applications page, click the Excel Services service application that you want to manage.

  3. 在 [管理 Excel Services] 頁面上按一下 [使用者定義的函數組件]。On the Manage Excel Services page, click User Defined Function Assemblies.

  4. 在 [Excel Services 使用者定義的函數] 頁面上,指向您想要編輯、 按一下出現箭號,然後按一下 [編輯使用者定義的函數組件。On the Excel Services User Defined Functions page, point to the user-defined function assembly that you want to edit, click the arrow that appears, and then click Edit.

  5. 依需要更新組件詳細資料並再按一下 [確定]Update the assembly details as needed, and then click OK.

取消登錄使用者定義的函數組件Unregister a user-defined function assembly

使用下列程序從使用者定義的函數組件清單中移除使用者定義的函數組件。Use the following procedure to remove a user-defined function assembly from the user-defined function assembly list.

若要取消登錄使用者定義的函數組件To unregister a user-defined function assembly

  1. 在管理中心首頁上,按一下 [應用程式管理] 區段中的 [管理服務應用程式]。On the Central Administration home page, in the Application Management section, click Manage service applications.

  2. 在 [管理服務應用程式] 頁面上,按一下您想要管理 Excel Services 服務應用程式。On the Manage Service Applications page, click the Excel Services service application that you want to manage.

  3. 在 [管理 Excel Services] 頁面上按一下 [使用者定義的函數組件]。On the Manage Excel Services page, click User Defined Function Assemblies.

  4. 在 [Excel Services 使用者定義的函數] 頁面上,指向您要刪除、 按一下出現箭號,然後按一下 [刪除的使用者定義的函數組件。On the Excel Services User Defined Functions page, point to the user-defined function assembly that you want to delete, click the arrow that appears, and then click Delete.

  5. 按一下 [詢問您是否要刪除的訊息方塊中的[確定]Click OK in the message box that asks whether you want to proceed with the deletion.

另請參閱See also

其他資源Other Resources

在 SharePoint 中設定 Excel ServicesConfigure Excel Services in SharePoint