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.

Reference

• Microsoft.Office.Excel.Server.WebServices
  The Excel Web Services API.