Excel Web Services

This section contains information about Excel Web Services and explains how to use it to develop custom applications.

In this section

What's New in Excel Web Services

Learn about the new types and members added to Excel Web Services in Microsoft SharePoint Server 2010.

Accessing the SOAP API

Learn how to call the Web service by referencing the Excel Web Services Web Services Description Language (WSDL).

Loop-Back SOAP Calls and Direct Linking

Learn when to link to Microsoft.Office.Excel.Server.WebServices.dll locally.

Walkthrough: Developing a Custom Application Using Excel Web Services

Get step-by-step instructions about how to create a Web service client application that accesses Excel Web Services.

Excel Services Error Codes

Read about the error codes for Excel Web Services alerts and the associated messages, explanations, and resolutions.

How to: Set Credentials

Learn how to set credentials for your users so that they can call Excel Web Services by using your custom applications.

How to: Get an Entire Workbook or a Snapshot

Learn how to get an entire workbook, a snapshot of the file, or a snapshot of the viewable sheets or objects in the file by using Excel Web Services.

How to: Save a Workbook

Learn about using the various libraries in the Microsoft .NET Framework to save a workbook.

How to: Get Values from Ranges

See examples of the four methods for getting values from an Excel workbook.

How to: Set Values of Ranges

Learn how to use the four methods for setting values in an Excel workbook.

How to: Specify a Range Address and Sheet Name

Learn how to specify range addresses by using range coordinates, named ranges, rows, and columns. Also learn how to specify a sheet name, and about the relationship between a sheet name and a range address.

How to: Use the CloseWorkbook Method Call Asynchronously

Find out how to close a workbook asynchronously to save some operation time.

How to: Refresh Data

Learn how you can use the Refresh method to retrieve updated data from external data sources for an open workbook.

How to: Use the SubCode Property to Capture Error Codes

Get examples that show how to capture Excel Services error codes when using SOAP and when using direct linking.



The Excel Web Services API.

See also

Other resources

Excel Services Class Library and Web Service Reference