0 out of 3 rated this helpful - Rate this topic

Excel Web Services

SharePoint 2010

Other Versions

SharePoint 2007

Published: May 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.

Reference

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

Other Resources

Excel Services Class Library and Web Service Reference

Change History

Date	Description	Reason
May 2010	Initial publication

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD