| div align="center"> | | | | By using the ECMAScript object model, you can build |
| If your team has difficulty managing and maintain Excel | | | | mashups and other integrated solutions that interact |
| workbooks developed over the years for your | | | | with one or more Excel Web Access Web Part |
| business, then it can benefit from the convenience | | | | controls on a page or an iframe with script on the |
| provided by SharePoint Excel Services. | | | | page. It also enables you to add more capabilities to |
| SharePoint’s Excel Services, first | | | | your workbooks and code around them. |
| introduced in Microsoft Office SharePoint Server 2007, | | | | • Representational State Transfer |
| is a service application that enables you to load, | | | | (REST) service: The REST API in Excel Services |
| calculate, and display Microsoft Excel workbooks on | | | | enables you to access workbook parts or elements |
| Microsoft SharePoint Server 2010. Excel Services help | | | | directly through a URL. The URL contains a |
| you to reuse and share Excel workbooks on | | | | “marker†path, which |
| SharePoint Server 2010 portals and dashboards. For | | | | is the entry point to an .aspx page, to the workbook |
| instance, financial analysts, business planners, etc. can | | | | file location, and to the path to the requested element |
| create content in Excel sheets and share it with others | | | | inside the workbook. |
| by using a SharePoint Server 2010 portal and | | | | • Excel Calculation Services: The |
| dashboard—without writing custom | | | | role of Excel Calculation Services is to load |
| code. The data displayed can be controlled by you. | | | | workbooks, calculate workbooks, call custom code |
| You can maintain a single version of your Excel | | | | (UDFs), and refresh external data. It also maintains the |
| workbook. | | | | session state for interactivity. Excel Calculation |
| Take advantage of SharePoint Excel Services and | | | | Services maintains a session for the duration of |
| other useful features of SharePoint 2010 hosting, | | | | interactions with the same workbook by a user or |
| SharePoint Foundation hosting or SharePoint Server | | | | caller. |
| 2010 - with shared or dedicated hosting by a | | | | Excel Services supports many features and scenarios |
| SharePoint 2010 hosting provider. | | | | which include the following:o Business Intelligence Portal |
| Excel Services is built on ASP.NET and SharePoint | | | | and Workbook Analysis: A business intelligence portal |
| Foundation technologies and includes the following core | | | | displays scorecards and reports, and enables users to |
| components: | | | | explore data by using only a browser. Excel Services |
| • Excel Web Access: Excel Web | | | | participates in the BI Center by providing the ability to |
| Access is a viewer page and an Excel Services Web | | | | calculate and expose Excel-based content on |
| Part that you can add to any Web Parts page in | | | | integrated BI dashboards.o Workbooks Management: |
| SharePoint Server 2010. Excel Web Access renders | | | | The workbook management capability of the Excel |
| (in other words, creates the HTML for) live Excel | | | | services maintain only one copy of a workbook |
| workbooks on a Web page, and enables the user to | | | | created and changed by a trusted author in a central, |
| interact with those workbooks and explore them. | | | | secure place. It secures and protects workbook |
| • Excel Web Services: Excel Web | | | | models and back-end data. Excel services also helps |
| Services is the Excel Services component that | | | | create snapshots of a workbook.o Custom |
| provides programmatic access to its Web service. | | | | Applications: Excel Services help create custom |
| You can develop applications that call Excel Web | | | | applications—for example, ASP.NET |
| Services to calculate, set, and extract values from | | | | applications—that |
| workbooks, and to refresh external data connections. | | | | 1. Call Excel Web Services to access, parameterize, |
| By using Excel Web Services, you can incorporate | | | | and calculate workbooks. |
| server-side workbook logic into an application, | | | | 2. Open, refresh external data, set cells or ranges, |
| automate the updating of Excel workbooks, and | | | | recalculate, participate in collaborative editing sessions |
| create application-specific user interfaces around | | | | with other applications or people, save, and save as. |
| server-side Excel calculation. | | | | 3. Use custom workflows to schedule calculation |
| • User-defined functions (UDFs): | | | | operations or send e-mail notifications. |
| Excel Services UDFs enable you to use formulas in a | | | | Above all this, in multiple server configurations, Excel |
| cell to call custom functions that are written in | | | | Services load-balances requests across multiple Excel |
| managed code and deployed to SharePoint Server | | | | Calculation Services occurrences in a farm |
| 2010. | | | | configuration. If your installation includes multiple |
| • ECMAScript (JavaScript, JScript): | | | | application servers, Excel Services will balance the |
| The ECMAScript object model in Excel Services | | | | load in an attempt to help ensure that no single |
| enable developers to customize, automate, and drive | | | | application server is overloaded by requests. |
| the Excel Web Access Web Part control on a page. | | | | |