Excel Services Development RoadmapExcel Services Development Roadmap

An important aspect of Excel Services is that solution developers can use its power programmatically from their applications. These applications can be line-of-business (LOB) products or custom enterprise solutions that an organization develops internally.An important aspect of Excel Services is that solution developers can use its power programmatically from their applications. These applications can be line-of-business (LOB) products or custom enterprise solutions that an organization develops internally.

Following are examples of these applications:Following are examples of these applications:

  • Multitiered applications, with the presentation layer implemented as a Web application (for example, an ASP.NET application) that calls Excel Web Services.Multitiered applications, with the presentation layer implemented as a Web application (for example, an ASP.NET application) that calls Excel Web Services.

  • Applications within Microsoft SharePoint Server 2010, or integrated with LOB products.Applications within Microsoft SharePoint Server 2010, or integrated with LOB products.

There are five types of development that you can do by using Excel Services:There are five types of development that you can do by using Excel Services:

  • Develop solutions by using Excel Web ServicesDevelop solutions by using Excel Web Services

  • Extend the Microsoft Excel function library in Excel Services by using user-defined functions (UDFs)Extend the Microsoft Excel function library in Excel Services by using user-defined functions (UDFs)

  • Personnaliser le composant WebPart Excel Web AccessCustomize the Excel Web Access web part

  • Develop solutions by using ECMAScript (JavaScript, JScript)Develop solutions by using ECMAScript (JavaScript, JScript)

  • Use the REST API to perform operations against Excel workbooksUse the REST API to perform operations against Excel workbooks

Excel Web ServiceExcel Web Service

Following are the main scenarios for Excel Web Services:Following are the main scenarios for Excel Web Services:

  • Server-side Excel calculationServer-side Excel calculation

    This scenario is application-centric. In this scenario, you use models defined in Excel workbooks and calculated on the server as part of application logic.This scenario is application-centric. In this scenario, you use models defined in Excel workbooks and calculated on the server as part of application logic.

  • Automating workbook updates on the serverAutomating workbook updates on the server

    This scenario is file-centric. In this scenario, Excel Web Services processes a workbook, and saves copies of the workbook or snapshots.This scenario is file-centric. In this scenario, Excel Web Services processes a workbook, and saves copies of the workbook or snapshots.

  • Opening workbooks in edit sessionsOpening workbooks in edit sessions

    Excel Web Services supports opening workbooks in edit sessions in SharePoint Server 2010. In this scenario, you can use code to edit a workbook.Excel Web Services supports opening workbooks in edit sessions in SharePoint Server 2010. In this scenario, you can use code to edit a workbook.

Server-Side Excel CalculationServer-Side Excel Calculation

For server-side Excel calculation, a custom application typically uses an Excel model as part of its logic. Instead of having to re-code Excel workbook business logic in a programming language, the business user can maintain the model in Excel in a server location. The developer never needs to change a line of code in the application that uses the model created by the business user.For server-side Excel calculation, a custom application typically uses an Excel model as part of its logic. Instead of having to re-code Excel workbook business logic in a programming language, the business user can maintain the model in Excel in a server location. The developer never needs to change a line of code in the application that uses the model created by the business user.

In this scenario, the custom application repeatedly calls Excel Web Services, which sends the calls to a back-end calculation service. Services de calcul Excel does the following:In this scenario, the custom application repeatedly calls Excel Web Services, which sends the calls to a back-end calculation service. Excel Calculation Services does the following:

  • Loads the specified Excel workbookLoads the specified Excel workbook

  • Receives inputsReceives inputs

  • Processes the workbook (for example, refreshes data or performs calculations)Processes the workbook (for example, refreshes data or performs calculations)

  • Sends the results to the custom applicationSends the results to the custom application

Automating Workbook Updates on the ServerAutomating Workbook Updates on the Server

When developers automate the updating of Excel workbooks on the server, they often have two objectives:When developers automate the updating of Excel workbooks on the server, they often have two objectives:

  • Generate Excel files or modify Excel templates by using the Formats de fichier Open XML, and then calculate the generated Excel file.Generate Excel files or modify Excel templates by using the Open XML File Formats, and then calculate the generated Excel file.

  • Periodically open an Excel file to refresh external data (once, or maybe multiple times per user), and then calculate the resulting workbooks and save them or send them in e-mail messages to various users.Periodically open an Excel file to refresh external data (once, or maybe multiple times per user), and then calculate the resulting workbooks and save them or send them in e-mail messages to various users.

In this scenario, a custom application uses Excel Web Services to do the following:In this scenario, a custom application uses Excel Web Services to do the following:

  • Load the specified Excel workbookLoad the specified Excel workbook

  • Input parametersInput parameters

  • Process the workbook (for example, refresh data or perform calculations)Process the workbook (for example, refresh data or perform calculations)

The custom application retrieves the live version of the workbook or snapshot and then saves the workbook or snapshot by using Excel Web Services.The custom application retrieves the live version of the workbook or snapshot and then saves the workbook or snapshot by using Excel Web Services.

Note

[!REMARQUE] When you make changes to a workbook—for example, by setting values to a range by using Excel Web Services—the changes to the workbook are preserved only for that particular session. The changes are not saved or persisted back to the original workbook. When the current workbook session ends (for example, when you call the CloseWorkbook method, or when the session times out), changes that you made are lost.> If you want to save changes that you make to a workbook, you can use the GetWorkbook method and then save the workbook by using the SaveWorkbook method or the SaveWorkbookCopy method. For more information about the Excel Web Services API, see Microsoft.Office.Excel.Server.WebServices .When you make changes to a workbook—for example, by setting values to a range by using Excel Web Services—the changes to the workbook are preserved only for that particular session. The changes are not saved or persisted back to the original workbook. When the current workbook session ends (for example, when you call the CloseWorkbook method, or when the session times out), changes that you made are lost.> If you want to save changes that you make to a workbook, you can use the GetWorkbook method and then save the workbook by using the SaveWorkbook method or the SaveWorkbookCopy method. For more information about the Excel Web Services API, see Microsoft.Office.Excel.Server.WebServices .

Using Excel Web ServicesUsing Excel Web Services

You can use Excel Web Services as:You can use Excel Web Services as:

  • A regular Web service, by calling the Web methods through SOAP over HTTP.A regular Web service, by calling the Web methods through SOAP over HTTP.

  • A local assembly, by linking directly to Microsoft.Office.Excel.Server.Webservices.dll.A local assembly, by linking directly to Microsoft.Office.Excel.Server.Webservices.dll.

For more information about when you should link directly to Microsoft.Office.Excel.Server.Webservices.dll, see Loop-Back SOAP Calls and Direct Linking.For more information about when you should link directly to Microsoft.Office.Excel.Server.Webservices.dll, see Loop-Back SOAP Calls and Direct Linking.

For information about the Excel Web Services API, see the Microsoft.Office.Excel.Server.Webservices namespace reference documentation. For an example of how to develop a custom application by using Excel Web Services, see Procédure pas à pas : développement d'une application personnalisée à l'aide des services Web Excel.For information about the Excel Web Services API, see the Microsoft.Office.Excel.Server.Webservices namespace reference documentation. For an example of how to develop a custom application by using Excel Web Services, see Walkthrough: Developing a Custom Application Using Excel Web Services.

User-Defined Functions (UDFs)User-Defined Functions (UDFs)

Excel Services supports managed-code UDFs. Excel Services UDFs give you the ability to use formulas in cells to call custom functions written in managed code and deployed to SharePoint Server 2010. You can create UDFs to:Excel Services supports managed-code UDFs. Excel Services UDFs give you the ability to use formulas in cells to call custom functions written in managed code and deployed to SharePoint Server 2010. You can create UDFs to:

  • Call custom mathematical functions.Call custom mathematical functions.

  • Get data from custom data sources into worksheets.Get data from custom data sources into worksheets.

  • Call Web services from the UDFs.Call Web services from the UDFs.

  • Wrap calls to existing native code library functions—for example, existing Excel UDFs.Wrap calls to existing native code library functions—for example, existing Excel UDFs.

For more information about Excel Services UDFs, see Understanding Excel Services UDFs.For more information about Excel Services UDFs, see Understanding Excel Services UDFs.

Using UDFsUsing UDFs

For information about Excel Services UDF definitions, see the Microsoft.Office.Excel.Server.Udf namespace reference documentation.For information about Excel Services UDF definitions, see the Microsoft.Office.Excel.Server.Udf namespace reference documentation.

For an example of how to create managed-code UDFs, see Walkthrough: Developing a Managed-Code UDF.For an example of how to create managed-code UDFs, see Walkthrough: Developing a Managed-Code UDF.

Excel Web AccessExcel Web Access

Vous pouvez utiliser les propriétés extensibles du composant WebPart Excel Web Access pour :You can use the extensible properties of the Excel Web Access web part to:

  • Configure Excel Web Access programmatically.Configure Excel Web Access programmatically.

  • Change Excel Web Access properties programmatically.Change Excel Web Access properties programmatically.

  • Appliquer un thème ou personnaliser une page de composants WebPart à l’aide de feuilles de style en cascade (CSS).Apply a theme or brand a web part page by using cascading style sheets (CSS).

Utilisation de l’extensibilité du composant WebPart Excel Web AccessUsing Excel Web Access web part Extensibility

For information about:For information about:

  • Propriétés extensibles Excel Web Access, consultez la documentation de référence d’espace de noms Microsoft.Office.Excel.Server.WebUI .Excel Web Access extensible properties, see the Microsoft.Office.Excel.Server.WebUI namespace reference documentation.

  • Excel Web Access CSS, see the CSS reference documentation.Excel Web Access CSS, see the CSS reference documentation.

  • Comment par programme configurer un composant WebPart, voir le Kit de développement SharePoint Foundation.How to programmatically configure a web part, see the SharePoint Foundation SDK.

ECMAScript (JavaScript, JScript)ECMAScript (JavaScript, JScript)

Dans SharePoint Server 2010, Excel Services ajouté la prise en charge de JavaScript. Le modèle objet JavaScript dans Excel Services permet aux développeurs d’automatiser, personnaliser et interagir avec le contrôle de composant WebPart Excel Web Access sur une page. À l’aide du modèle objet JavaScript, vous pouvez créer des applications Web hybrides et autres solutions intégrées qui interagissent avec un ou plusieurs Excel Web Access web part contrôles sur une page. Il permet également à ajouter des fonctionnalités supplémentaires à vos classeurs et le code qui les entoure.In SharePoint Server 2010, Excel Services added support for JavaScript. The JavaScript object model in Excel Services enables developers to automate, customize, and interact with the Excel Web Access web part control on a page. By using the JavaScript object model, you can build mashups and other integrated solutions that interact with one or more Excel Web Access web part controls on a page. It also enables you to add more capabilities to your workbooks and code around them.

For more information about the JavaScript object model in Excel Services, see the Ewa namespace reference documentation.For more information about the JavaScript object model in Excel Services, see the Ewa namespace reference documentation.

Using ECMAScript (JavaScript, JScript)Using ECMAScript (JavaScript, JScript)

For more information about JavaScript, see the following links:For more information about JavaScript, see the following links:

REST APIREST API

The REST API in Excel Services is new in SharePoint Server 2010. By using the REST API, you can access workbook parts or elements directly through a URL.The REST API in Excel Services is new in SharePoint Server 2010. By using the REST API, you can access workbook parts or elements directly through a URL.

The discovery mechanisms built into the Excel Services REST API also enable developers and users to explore the content of a workbook manually or programmatically, by supplying Atom feeds that contain information about the elements that reside in a specific workbook. The resources that you can access through the REST API are ranges, charts, tables, and PivotTables.The discovery mechanisms built into the Excel Services REST API also enable developers and users to explore the content of a workbook manually or programmatically, by supplying Atom feeds that contain information about the elements that reside in a specific workbook. The resources that you can access through the REST API are ranges, charts, tables, and PivotTables.

Using the Atom feed provided by the REST API enables an easier way to get to the data that you care about. The feed contains traversable elements that allow any piece of code to discover what elements exist in a workbook.Using the Atom feed provided by the REST API enables an easier way to get to the data that you care about. The feed contains traversable elements that allow any piece of code to discover what elements exist in a workbook.

For more information, see Excel Services REST API.For more information, see Excel Services REST API.

Using the REST APIUsing the REST API

For information about:For information about:

Voir aussiSee also

TâchesTasks

Comment : ajouter par programme un composant WebPart Excel Web Access à une PageHow to: Programmatically Add an Excel Web Access web part to a Page

ConceptsConcepts

Vue d'ensemble d'Excel ServicesExcel Services Overview

Architecture d'Excel ServicesExcel Services Architecture

Fonctionnalités prises en charge et non prises en chargeSupported and Unsupported Features

Blogs sur Excel ServicesExcel Services Blogs, Forums, and Resources

Autres ressourcesOther resources

Procédure pas à pas : développement d'une application personnalisée à l'aide des services Web ExcelWalkthrough: Developing a Custom Application Using Excel Web Services