Excel Web Services
This section contains information about Excel Web Services and explains how to use it to develop custom applications.
In This Section
- Accessing the SOAP API
Find out how to call the Web service by referencing the Excel Web Services WSDL (Web Services Description Language).
- 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 on 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 they can call Excel Web Services 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 some 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, how to specify a sheet name, and 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 the 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.