SharePoint Server 2013 的 Excel Services 概觀Overview of Excel Services in SharePoint Server 2013

摘要:Excel Services 為 SharePoint Server 2013,可讓您組織中共用資料連線的活頁簿中的商務智慧工具。Summary: Excel Services is a business intelligence tool in SharePoint Server 2013 that allows you to share data-connected workbooks across an organization.

Excel Services 是可用來將在 SharePoint Server 2013 的 Excel 活頁簿發佈的共用的服務。已發佈的活頁簿可以受管理與安全依據您組織的需求和 SharePoint Server 2013 使用者可轉譯在瀏覽器中的活頁簿之間共用。Excel Services 是只適用於 SharePoint Server 2013 Enterprise edition。Excel Services is a shared service that you can use to publish Excel workbooks on SharePoint Server 2013. The published workbooks can be managed and secured according to your organizational needs and shared among SharePoint Server 2013 users, who can render the workbooks in a browser. Excel Services is available only in the Enterprise edition of SharePoint Server 2013.

Excel Services 主要用於商務智慧案例。Excel 活頁簿可以連線至外部資料來源、 建立、 報表,然後可將活頁簿發佈至 SharePoint 文件庫。當使用者開啟活頁簿中的的文件庫,它呈現的瀏覽器中使用 Excel Services。外部資料連線會維護,而且如果需要重新整理資料。這可讓廣泛共用的整個組織中的報表。Excel Services is used primarily for business intelligence scenarios. Excel workbooks can be connected to external data sources, reports created, and then the workbook can be published to a SharePoint document library. When a user opens the workbook from the the document library, it is rendered in the browser by using Excel Services. The external data connection is maintained and the data is refreshed if necessary. This allows broad sharing of reports throughout an organization.

Excel Services 是由 Excel Calculation Services、 Excel Web Access 網頁組件,與 Excel Web Services 的程式設計存取所組成。支援共用、 保護、 管理,並使用 Excel 活頁簿的瀏覽器中提供下列:Excel Services consists of Excel Calculation Services, the Excel Web Access Web Part, and Excel Web Services for programmatic access. It supports sharing, securing, managing, and using Excel workbooks in a browser by providing the following:

  • 管理活頁簿的通用設定,包括安全性、負載平衡、工作階段管理、記憶體使用率、活頁簿快取和外部資料連線等設定。Global settings for managing workbooks, which include settings for security, load balancing, session management, memory utilization, workbook caches, and external data connections.

  • 信任的檔案位置 (可讓您定義的 Excel Services 信任的文件庫) 與工作階段管理、 活頁簿大小、 計算方式及這些位置中儲存的活頁簿的外部資料設定。Trusted file locations (which allow you to define which document libraries are trusted by Excel Services) together with session management, workbook size, calculation behavior, and external data settings of workbooks stored in those locations.

  • 信任的資料提供者 (可以連線到資料的提供者) 的詳盡清單,再加上可以加入信任的資料提供者的能力。An extensive list of trusted data providers for connecting to your data, plus the ability to add your own trusted data provider.

  • 可讓您在伺服器陣列中定義的資料連線庫的受信任的資料連線庫,是由 Excel Services 信任的。Trusted data connection libraries, which allow you to define which data connection libraries in your farm are trusted by Excel Services.

  • 加入您的使用者定義函數組件的功能。The ability to add your own user-defined function assemblies.

使用者可以透過 Excel Services 在瀏覽器中的 Excel 活頁簿與互動,而無法編輯活頁簿在瀏覽器中使用 Excel Services。可以使用以程式設計方式的選項。While users can interact with Excel workbooks in a browser through Excel Services, the workbooks cannot be edited in the browser by using Excel Services. Programmatic options are available.

查看幾個特定案例可以協助您了解如何善加利用 Excel Services:Looking at several specific scenarios can help you understand how best to take advantage of Excel Services:

  • 共用活頁簿使用者可以將 Excel 活頁簿儲存至其他讓使用者能夠瀏覽器存取活頁簿的計算伺服器版本的 SharePoint Server 文件庫。在存取活頁簿時 Excel Services 載入活頁簿,系統會重新整理外部資料視需要,計算如果它是必要的並傳送所產生的輸出檢視回透過瀏覽器。使用者可以與 Excel 基礎資料互動來排序、 篩選、 展開,或摺疊樞紐分析表,並傳遞的參數。這可讓您在已發佈的活頁簿上執行分析。使用者沒有在 Excel 中檢視活頁簿安裝。使用者將會一律檢視最新版的活頁簿和他們可以在瀏覽器上互動。限制哪些 access 提供給哪些使用者可以設定安全性權限。Sharing workbooks Users can save Excel workbooks to a SharePoint Server document library to give other users browser-based access to the server-calculated version of the workbook. When the workbook is accessed, Excel Services loads the workbook, refreshes the external data if it is necessary, calculates it if it is necessary, and sends the resulting output view back through the browser. A user can interact with Excel-based data by sorting, filtering, expanding, or collapsing PivotTables, and by passing in parameters. This provides the ability to perform analysis on published workbooks. A user does not have to have Excel installed to view the workbook. Users will always view the latest version of a workbook, and they can interact with it in a browser. Security permissions can be set to limit what access is provided to which user.

  • 建立商務智慧 (BI) 儀表板使用 Excel 與 Excel Services 與 Excel Web Access 網頁組件可以建立瀏覽器為基礎的儀表板。PerformancePoint Services 也可以使用 Excel Services 活頁簿作為資料來源。Building business intelligence (BI) dashboards Browser-based dashboards can be created by using Excel and Excel Services together with the Excel Web Access Web Part. PerformancePoint Services can also use Excel Services workbooks as a data source.

  • 重複使用的邏輯封裝在 Excel 活頁簿中的自訂應用程式除了與伺服器的瀏覽器為基礎的介面,Excel Services 提供 Web 服務為基礎的介面,讓已發佈的活頁簿可以程式設計方式存取任何使用 Web 服務的應用程式。Web 服務應用程式可以變更值、 計算活頁簿,及使用該介面根據針對已發佈的活頁簿設定安全性權限來擷取某些或所有更新的活頁簿。Reuse of logic encapsulated in Excel workbooks in custom applications Besides a browser-based interface with the server, Excel Services provides a Web-service-based interface so that a published workbook can be accessed programmatically by any application that uses Web services. The Web service applications can change values, calculate the workbook, and retrieve some or all of the updated workbook by using that interface according to what security permissions are set for the published workbook.

  • 報表建置其中一個最有用的 Excel Services 功能是報表建置。由資料連線活頁簿發佈至 SharePoint 文件庫,並建立其可透過 Excel Services,您可以讓您已在組織中提供給其他人的 Excel 中建立的報表。而不是其電腦具有不同的活頁簿的複本的多位使用者,可以建立而變更由受信任作者在 Excel Services 信任的集中位置的活頁簿。正確版本的工作表會比較容易尋找、 分享和使用合併 Excel、 SharePoint Server 和其他應用程式。Report Building One of the most useful features of Excel Services is report building. By publishing data-connected workbooks to a SharePoint document library and making them available through Excel Services, you can make reports that you have created in Excel available to others in your organization. Instead of multiple users having separate copies of the workbooks on their computers, the workbooks can be created and changed by a trusted author in a central location that is trusted by Excel Services. The correct version of the worksheet is easier to find, share, and use from Excel, SharePoint Server, and other applications.

使用 Office Web Apps Server 伺服器陣列Farms using Office Web Apps Server

如果您的 SharePoint 伺服器陣列已整合 Office Web Apps Server 與 Excel Web App、 Excel Services 的可用功能取決於 Excel Web App 設定方式。If your SharePoint Server farm has been integrated with Office Web Apps Server and Excel Web App, the features available in Excel Services will depend on how Excel Web App has been configured.

Excel Web App 在兩種模式之一下執行:Excel Web App runs in one of two modes:

  • SharePoint 檢視模式在本模式中,Excel Services 用來在瀏覽器中檢視活頁簿。SharePoint view mode In this mode, Excel Services is used to view workbooks in the browser.

  • Office Web Apps Server 檢視模式在本模式中,Excel Web App 用來在瀏覽器中檢視活頁簿。Office Web Apps Server view mode In this mode, Excel Web App is used to view workbooks in the browser.

下表列出每個模式可用的 Excel services 的商務智慧功能。The following table lists the business intelligence features available in Excel Services in each mode.

依模式的 Excel Services 中的商務智慧功能BI features in Excel Services, by mode

僅適用於 SharePoint ServerSharePoint Server only SharePoint Server 與 Excel Web App (SharePoint 檢視模式)SharePoint Server with Excel Web App (SharePoint view mode) SharePoint Server 與 Excel Web App (Office Web Apps Server 檢視模式)SharePoint Server with Excel Web App (Office Web Apps Server view mode)
Excel Web Access 網頁組件Excel Web Access Web Part
××
××
重新整理 OData 連線Refresh OData connections
××
××
檢視和互動 Power View 報表。View and interact with Power View reports
××
××
檢視和互動 Power Pivot 資料模型View and interact with Power Pivot data models
××
××
重新整理 Power Pivot 資料模型Refresh Power Pivot data models
××
××
使用 Excel Services 自動的服務帳戶重新整理資料Refresh data by using the Excel Services unattended service account
××
××
使用 Secure Store 和 Windows 認證重新整理資料Refresh data by using Secure Store and Windows credentials
××
××
××
使用 Effective User Name 連線重新整理資料Refresh data by using Effective User Name connections
××
××
Kerberos 委派Kerberos delegation
××
××

See alsoSee also

概念Concepts

商務智慧功能的 Excel Service (SharePoint Server 2013)Business intelligence capabilities in Excel Service (SharePoint Server 2013)