Accessing the SOAP API
Excel Web Services uses Simple Object Access Protocol (SOAP) over HTTP and acts as a communications interface between client programs and Excel Services. The Web service consists of methods and a set of complex type objects that you can use to access the complete functionality of Excel Web Services. To call the service, you must reference the Excel Web Services Web Services Description Language (WSDL).
Referencing the WSDL
To call a Web service successfully, you must know how to access the service, what operations the service supports, what parameters the service expects, and what the service returns. WSDL provides this information in an XML document that can be read or processed by a computer.
The WSDL for the Excel Web Services endpoint is accessed through ExcelServices.asmx?wsdl. WSDL can be consumed by development kits that support SOAP and Web services, such as the Microsoft .NET Framework SDK.
The following example shows the format of the URL to the Excel Web Services WSDL file:
http://<server>/<customsite>/_vti_bin/excelservice.asmx?WSDL
If you do not have a custom site, you can use the following URL temporarily:
http://<server>/_vti_bin/excelservice.asmx?WSDL
It is recommended that you create a custom site, and then use the URL that includes the custom site in the URL format.
The following table describes each element in the URL.
| URL element | Description |
|---|---|
server |
The name of the server on which Microsoft Office SharePoint Server 2007 is deployed. |
customsite |
A custom Office SharePoint Server 2007 site that the server administrator creates. |
<endpointname>.asmx |
The name of the Web service endpoint. For Excel Web Services, it is |
For more information about the WSDL format, see the World Wide Web Consortium (W3C) WSDL specification at http://www.w3.org/TR/wsdl.
See Also
Tasks
Step 1: Creating the Web Service Client Project
Step 2: Adding a Web Reference
Step 3: Accessing the Web Service
Step 4: Building and Testing the Application
Walkthrough: Developing a Custom Application Using Excel Web Services
How to: Trust Workbook Locations Using Script