Excel Web Services
Applies to: SharePoint Server 2010
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.