在 英语 中使用 Excel services 的示例及其翻译为 中文
{-}
-
Political
-
Ecclesiastic
-
Programming
Excel Services and data source support.
Data sources that are supported in Excel Services.
(Excel Services is used to render workbooks).
Plan external data connections for Excel Services.
An Excel Services report might resemble the following image:.
Note: Not all Excel features are supported by Excel Services.
Excel Services can be set up so that only trusted connections can be used.
Create a basic sales dashboard using Excel and Excel Services.
Determining whether Excel Services or Excel Web App is used to render a workbook.
Create a basic sales dashboard using Excel and Excel Services.
The information in this article applies to Excel Services in SharePoint Server 2013(on premises) only.
The web parts can connect to a diverse range of data sources including: databases, SP Lists,BDC and Excel Services.
Note: The authentication setting is only used by Excel Services, and not by Microsoft Excel. .
The web parts can connect to a diverse range of data sources including: databases, SP Lists,BDC and Excel Services.
Note: The authentication setting is only used by Excel Services, and not by Microsoft Excel. .
If Excel Services is configured in your environment, then you can publish workbooks that can be displayed in a browser window.
For more information, see Work with external data in Excel Services(SharePoint Server).
SharePoint also provides data analysis tools, like Performance Point Services and Visio Services that enable business intelligence,and powerful new features in Excel Services.
Similar to scorecards and analytic charts and grids, Excel Services reports are typically highly interactive.
Microsoft is currently working to offer such features,and provides an early version of this capability in Microsoft Excel Services.
Note: The authentication setting is only used by Excel Services, and not by Microsoft Excel. .
Controlled distribution of financial data to clients and business partners A bank deploys a solutionbased on MOSS 2007 to take advantage of Excel Services.
This article covers BI in Excel and Excel Services, but there are other Microsoft BI tools available.
Some, but not all, of the data sources that youcan use in Excel are supported in Excel Services in SharePoint Server 2013.
You can also use and refresh connected data in Excel Services, but there are additional limitations and workarounds that you should be aware of.
Create and use interactive dashboards with scorecards,reports(including Reporting Services and Excel Services Reports), and filters.
Note: The authentication setting is used only by Microsoft Excel Services, and not by the Excel desktop program.
Excel and its related services are no longer hosted on the SharePoint Server.