ExcelService

Click here for a complete list of operations.

GetSheetNames

Test

The test form is only available for requests from the local machine.

SOAP 1.1

The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.

POST /_vti_bin/ExcelService.asmx HTTP/1.1
Host: earnshawsc.eq.edu.au
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://schemas.microsoft.com/office/excel/server/webservices/GetSheetNames"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <GetSheetNames xmlns="http://schemas.microsoft.com/office/excel/server/webservices">
      <sessionId>string</sessionId>
    </GetSheetNames>
  </soap:Body>
</soap:Envelope>

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <GetSheetNamesResponse xmlns="http://schemas.microsoft.com/office/excel/server/webservices">
      <GetSheetNamesResult>
        <SheetInfo>
          <Name>string</Name>
          <Type>Worksheet or Chartsheet</Type>
          <Visibility>Visible or Hidden or VeryHidden</Visibility>
        </SheetInfo>
        <SheetInfo>
          <Name>string</Name>
          <Type>Worksheet or Chartsheet</Type>
          <Visibility>Visible or Hidden or VeryHidden</Visibility>
        </SheetInfo>
      </GetSheetNamesResult>
      <status>
        <Status>
          <Name>string</Name>
          <Severity>string</Severity>
          <Message>string</Message>
        </Status>
        <Status>
          <Name>string</Name>
          <Severity>string</Severity>
          <Message>string</Message>
        </Status>
      </status>
    </GetSheetNamesResponse>
  </soap:Body>
</soap:Envelope>

SOAP 1.2

The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.

POST /_vti_bin/ExcelService.asmx HTTP/1.1
Host: earnshawsc.eq.edu.au
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <GetSheetNames xmlns="http://schemas.microsoft.com/office/excel/server/webservices">
      <sessionId>string</sessionId>
    </GetSheetNames>
  </soap12:Body>
</soap12:Envelope>

HTTP/1.1 200 OK
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <GetSheetNamesResponse xmlns="http://schemas.microsoft.com/office/excel/server/webservices">
      <GetSheetNamesResult>
        <SheetInfo>
          <Name>string</Name>
          <Type>Worksheet or Chartsheet</Type>
          <Visibility>Visible or Hidden or VeryHidden</Visibility>
        </SheetInfo>
        <SheetInfo>
          <Name>string</Name>
          <Type>Worksheet or Chartsheet</Type>
          <Visibility>Visible or Hidden or VeryHidden</Visibility>
        </SheetInfo>
      </GetSheetNamesResult>
      <status>
        <Status>
          <Name>string</Name>
          <Severity>string</Severity>
          <Message>string</Message>
        </Status>
        <Status>
          <Name>string</Name>
          <Severity>string</Severity>
          <Message>string</Message>
        </Status>
      </status>
    </GetSheetNamesResponse>
  </soap12:Body>
</soap12:Envelope>