6 Appendix A: Full WSDL

SharePoint

For ease of implementation, the full WSDL is provided as follows.

 <?xml version="1.0" encoding="utf-8"?>
 <wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:tns="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/" xmlns:s1="http://microsoft.com/wsdl/types/" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" targetNamespace="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
   <wsdl:types>
     <s:schema elementFormDefault="qualified" targetNamespace="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/">
       <s:import namespace="http://microsoft.com/wsdl/types/" />
       <s:element name="CloseWorkbook">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:complexType name="CommandParameter">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="1" name="WorkbookId" type="s:string" />
           <s:element minOccurs="1" maxOccurs="1" name="StateId" type="s:int" />
           <s:element minOccurs="0" maxOccurs="1" name="VisibleSheetRangeRequest" type="tns:VisibleSheetRange" />
           <s:element minOccurs="0" maxOccurs="1" name="WorkOnBehalfRequest" type="tns:WorkOnBehalf" />
           <s:element minOccurs="0" maxOccurs="1" name="CredentialsResponse" type="tns:CredentialsResponse" />
           <s:element minOccurs="1" maxOccurs="1" name="Confirmation" type="tns:ExcelServerMessageId" />
           <s:element minOccurs="1" maxOccurs="1" name="ConfirmationChoice" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="EwrCall" type="s:boolean" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="VisibleSheetRange">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="1" name="SheetName" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="ObjectName" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="ExcelRange" type="s:string" />
           <s:element minOccurs="1" maxOccurs="1" name="FirstRow" type="s:int" />
           <s:element minOccurs="1" maxOccurs="1" name="VisibleRowsRequested" type="s:int" />
           <s:element minOccurs="1" maxOccurs="1" name="FirstColumn" type="s:int" />
           <s:element minOccurs="1" maxOccurs="1" name="VisibleColumnsRequested" type="s:int" />
           <s:element minOccurs="1" maxOccurs="1" name="VisibleFirstRowOffset" type="s:int" />
           <s:element minOccurs="1" maxOccurs="1" name="VisibleFirstColumnOffset" type="s:int" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="WorkOnBehalf">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="1" name="UserName" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="UserSid" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="UserToken" type="s:base64Binary" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="CredentialsResponse">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="1" name="Ticket" type="tns:SingleSignOnTicket" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="SingleSignOnTicket">
         <s:sequence>
           <s:element minOccurs="1" maxOccurs="1" name="FailedToReserveTicket" type="s:boolean" />
           <s:element minOccurs="0" maxOccurs="1" name="Value" type="s:string" />
         </s:sequence>
       </s:complexType>
 <s:simpleType name="ExcelServerMessageId">
   <s:restriction base="s:string">    
     <s:enumeration value="Blank"/>
     <s:enumeration value="ConfirmDataRefresh"/>
     <s:enumeration value="ExternalDataRefreshFailed"/>
     <s:enumeration value="ExternalDataRefreshFailed_Details"/>
     <s:enumeration value="PivotNoOverlapAllowed"/>
     <s:enumeration value="PivotOverlapList"/>
     <s:enumeration value="PivotCubeNotUnique"/>
     <s:enumeration value="NoDataItemsOlap"/>
     <s:enumeration value="OlapSchemaFail"/>
     <s:enumeration value="InvalidPivot"/>
     <s:enumeration value="OlapNoMoreDetail"/>
     <s:enumeration value="DrillActionInvalid"/>
     <s:enumeration value="DriverNotOlap"/>
     <s:enumeration value="CubeMissing"/>
     <s:enumeration value="SkipLine"/>
     <s:enumeration value="CDimMismatch"/>
     <s:enumeration value="DataSetAxisTooBig"/>
     <s:enumeration value="CubeIntegrityError"/>
     <s:enumeration value="PivotNotExpandedtoProtectCellContents"/>
     <s:enumeration value="PivotTruncatedSheetEdge"/>
     <s:enumeration value="DdlGrpNotSup"/>
     <s:enumeration value="PivotFormulasCollided"/>
     <s:enumeration value="NoRetItems"/>
     <s:enumeration value="OlapConnectVisualModeProvider"/>
     <s:enumeration value="PivotNoSourceData"/>
     <s:enumeration value="PivotFilteringError"/>
     <s:enumeration value="PivotTableIncorrectDateFormat"/>
     <s:enumeration value="PivotTableEndingLargerThanStarting"/>
     <s:enumeration value="PivotTableIncorrectNumberFormat"/>
     <s:enumeration value="PivotTableOutOfRange"/>
     <s:enumeration value="MergedCellOverlap"/>
     <s:enumeration value="PivotSourceNotAvailable"/>
     <s:enumeration value="UnexpectedPivotError"/>
     <s:enumeration value="UnsupportedUICulture"/>
     <s:enumeration value="UnsupportedDataCulture"/>
   </s:restriction>
 </s:simpleType>
       <s:element name="CloseWorkbookResponse">
         <s:complexType />
       </s:element>
       <s:element name="GetRange">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="GetRangeResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="GetRangeResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:complexType name="CommandResult">
         <s:sequence>
           <s:element minOccurs="1" maxOccurs="1" name="StateId" type="s:int" />
           <s:element minOccurs="0" maxOccurs="1" name="SpreadsheetData" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="ExtendedInfo" type="tns:CommandResultExtendedInfo" />
           <s:element minOccurs="0" maxOccurs="1" name="PeriodicRefreshInfo" type="tns:PeriodicRefreshInfo" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="CommandResultExtendedInfo">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="1" name="CredentialsRequest" type="tns:CredentialsRequest" />
           <s:element minOccurs="0" maxOccurs="1" name="Messages" type="tns:ArrayOfExcelServerMessage" />
           <s:element minOccurs="1" maxOccurs="1" name="WarnOnManualDataRefresh" type="s:boolean" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="CredentialsRequest">
         <s:sequence>
           <s:element minOccurs="1" maxOccurs="1" name="ReserveTicket" type="s:boolean" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="ArrayOfExcelServerMessage">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="unbounded" name="ExcelServerMessage" nillable="true" type="tns:ExcelServerMessage" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="ExcelServerMessage">
         <s:sequence>
           <s:element minOccurs="1" maxOccurs="1" name="HasOpenItemPermission" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="Id" type="tns:ExcelServerMessageId" />
           <s:element minOccurs="1" maxOccurs="1" name="Severity" type="tns:ExcelServerMessageSeverity" />
           <s:element minOccurs="1" maxOccurs="1" name="Type" type="tns:ExcelServerMessageType" />
           <s:element minOccurs="1" maxOccurs="1" name="Buttons" type="tns:ExcelServerMessageButtons" />
           <s:element minOccurs="0" maxOccurs="1" name="Description" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="ExtendedDescription" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="Caption" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="HelpTopicId" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="HelpDisplayText" type="s:string" />
         </s:sequence>
       </s:complexType>
 <s:simpleType name="ExcelServerMessageSeverity">
   <s:restriction base="s:string">
     <s:enumeration value="Error"/>
     <s:enumeration value="Warning"/>
   </s:restriction>
 </s:simpleType>
 <s:simpleType name="ExcelServerMessageType">
   <s:restriction base="s:string">
     <s:enumeration value="Alert"/>
     <s:enumeration value="Confirmation"/>
   </s:restriction>
 </s:simpleType>
  
 <s:simpleType name="ExcelServerMessageButtons">
   <s:list>
     <s:simpleType>
       <s:restriction base="s:string">
         <s:enumeration value="OK"/>
         <s:enumeration value="Yes"/>
         <s:enumeration value="No"/>
       </s:restriction>
     </s:simpleType>
   </s:list>
 </s:simpleType>
       <s:complexType name="PeriodicRefreshInfo">
         <s:sequence>
           <s:element minOccurs="1" maxOccurs="1" name="ExpirationTime" type="s:int" />
           <s:element minOccurs="0" maxOccurs="1" name="ConnectionNames" type="tns:ArrayOfString" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="ArrayOfString">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="unbounded" name="string" nillable="true" type="s:string" />
         </s:sequence>
       </s:complexType>
       <s:element name="GetRangeValues">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="sheetRange" type="tns:SheetRange" />
             <s:element minOccurs="1" maxOccurs="1" name="formatted" type="s:boolean" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:complexType name="SheetRange">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="1" name="SheetName" type="s:string" />
           <s:element minOccurs="1" maxOccurs="1" name="FirstRow" type="s:int" />
           <s:element minOccurs="1" maxOccurs="1" name="LastRow" type="s:int" />
           <s:element minOccurs="1" maxOccurs="1" name="FirstColumn" type="s:int" />
           <s:element minOccurs="1" maxOccurs="1" name="LastColumn" type="s:int" />
         </s:sequence>
       </s:complexType>
       <s:element name="GetRangeValuesResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="GetRangeValuesResult" type="tns:CommandResult" />
             <s:element minOccurs="0" maxOccurs="1" name="cellValues" type="tns:ArrayOfAnyType" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:complexType name="ArrayOfAnyType">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="unbounded" name="anyType" nillable="true" />
         </s:sequence>
       </s:complexType>
       <s:simpleType name="CellError">
         <s:restriction base="s:string">
           <s:enumeration value="Div0" />
           <s:enumeration value="NotApplicable" />
           <s:enumeration value="Name" />
           <s:enumeration value="Null" />
           <s:enumeration value="Num" />
           <s:enumeration value="Ref" />
           <s:enumeration value="Value" />
         </s:restriction>
       </s:simpleType>
       <s:element name="GetRangeValuesA1">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="sheetName" type="s:string" />
             <s:element minOccurs="0" maxOccurs="1" name="rangeName" type="s:string" />
             <s:element minOccurs="1" maxOccurs="1" name="formatted" type="s:boolean" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="GetRangeValuesA1Response">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="GetRangeValuesA1Result" type="tns:CommandResult" />
             <s:element minOccurs="0" maxOccurs="1" name="cellValues" type="tns:ArrayOfAnyType" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="CancelRequest">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="CancelRequestResponse">
         <s:complexType />
       </s:element>
       <s:element name="GetSessionInformation">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="GetSessionInformationResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="GetSessionInformationResult" type="tns:CommandResult" />
             <s:element minOccurs="0" maxOccurs="1" name="serverVersion" type="s:string" />
             <s:element minOccurs="0" maxOccurs="1" name="uiCultureName" type="s:string" />
             <s:element minOccurs="0" maxOccurs="1" name="dataCultureName" type="s:string" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="FindRange">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="searchTerm" type="s:string" />
             <s:element minOccurs="1" maxOccurs="1" name="searchUp" type="s:boolean" />
             <s:element minOccurs="0" maxOccurs="1" name="searchAfterCell" type="tns:SheetCell" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:complexType name="SheetCell">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="1" name="SheetName" type="s:string" />
           <s:element minOccurs="1" maxOccurs="1" name="Row" type="s:int" />
           <s:element minOccurs="1" maxOccurs="1" name="Column" type="s:int" />
         </s:sequence>
       </s:complexType>
       <s:element name="FindRangeResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="FindRangeResult" type="tns:CommandResult" />
             <s:element minOccurs="0" maxOccurs="1" name="foundCell" type="tns:SheetCell" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="GetAutoFilterItemList">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="autoFilterOptions" type="tns:AutoFilterOptions" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:complexType name="AutoFilterOptions">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="1" name="AutoFilterType" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="Criteria" type="tns:ArrayOfAutoFilterCriteria" />
           <s:element minOccurs="1" maxOccurs="1" name="CriteriaType" type="tns:AutoFilterCriteriaType" />
           <s:element minOccurs="1" maxOccurs="1" name="Id" type="s:unsignedInt" />
           <s:element minOccurs="0" maxOccurs="1" name="SheetName" type="s:string" />
           <s:element minOccurs="1" maxOccurs="1" name="Column" type="s:int" />
           <s:element minOccurs="1" maxOccurs="1" name="NamedObjectView" type="s:boolean" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="ArrayOfAutoFilterCriteria">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="unbounded" name="AutoFilterCriteria" nillable="true" type="tns:AutoFilterCriteria" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="AutoFilterCriteria">
         <s:sequence>
           <s:element minOccurs="1" maxOccurs="1" name="Type" type="tns:OperationType" />
           <s:element minOccurs="1" maxOccurs="1" name="Relation" type="tns:RelationOperator" />
           <s:element minOccurs="0" maxOccurs="1" name="Value" type="s:string" />
         </s:sequence>
       </s:complexType>
       <s:simpleType name="OperationType">
         <s:restriction base="s:string">
           <s:enumeration value="EQ" />
           <s:enumeration value="NEQ" />
           <s:enumeration value="GT" />
           <s:enumeration value="GTEQ" />
           <s:enumeration value="LT" />
           <s:enumeration value="LTEQ" />
           <s:enumeration value="LastCount" />
         </s:restriction>
       </s:simpleType>
       <s:simpleType name="RelationOperator">
         <s:restriction base="s:string">
           <s:enumeration value="Nil" />
           <s:enumeration value="And" />
           <s:enumeration value="Or" />
           <s:enumeration value="LastCount" />
         </s:restriction>
       </s:simpleType>
       <s:simpleType name="AutoFilterCriteriaType">
         <s:restriction base="s:string">
           <s:enumeration value="Nil" />
           <s:enumeration value="AboveAverage" />
           <s:enumeration value="BelowAverage" />
           <s:enumeration value="Tomorrow" />
           <s:enumeration value="Today" />
           <s:enumeration value="Yesterday" />
           <s:enumeration value="NextWeek" />
           <s:enumeration value="ThisWeek" />
           <s:enumeration value="LastWeek" />
           <s:enumeration value="NextMonth" />
           <s:enumeration value="ThisMonth" />
           <s:enumeration value="LastMonth" />
           <s:enumeration value="NextQuarter" />
           <s:enumeration value="ThisQuarter" />
           <s:enumeration value="LastQuarter" />
           <s:enumeration value="NextYear" />
           <s:enumeration value="ThisYear" />
           <s:enumeration value="LastYear" />
           <s:enumeration value="YearToDate" />
           <s:enumeration value="Q1" />
           <s:enumeration value="Q2" />
           <s:enumeration value="Q3" />
           <s:enumeration value="Q4" />
           <s:enumeration value="M1" />
           <s:enumeration value="M2" />
           <s:enumeration value="M3" />
           <s:enumeration value="M4" />
           <s:enumeration value="M5" />
           <s:enumeration value="M6" />
           <s:enumeration value="M7" />
           <s:enumeration value="M8" />
           <s:enumeration value="M9" />
           <s:enumeration value="M10" />
           <s:enumeration value="M11" />
           <s:enumeration value="M12" />
           <s:enumeration value="LastCount" />
         </s:restriction>
       </s:simpleType>
       <s:complexType name="AutoFilterItemList">
         <s:sequence>
           <s:element minOccurs="1" maxOccurs="1" name="ShowTime" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="ItemListMaxExceeded" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="IsBlanksSelected" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="HasBlanks" type="s:boolean" />
           <s:element minOccurs="0" maxOccurs="1" name="AutoFilterDateNodes" type="tns:ArrayOfAutoFilterDateNodeInfo" />
           <s:element minOccurs="0" maxOccurs="1" name="AutoFilterItems" type="tns:ArrayOfAutoFilterItem" />
           <s:element minOccurs="0" maxOccurs="1" name="SecondValues" type="tns:ArrayOfAnyType" />
           <s:element minOccurs="0" maxOccurs="1" name="SecondKeys" type="tns:ArrayOfAnyType" />
           <s:element minOccurs="0" maxOccurs="1" name="MinuteValues" type="tns:ArrayOfAnyType" />
           <s:element minOccurs="0" maxOccurs="1" name="MinuteKeys" type="tns:ArrayOfAnyType" />
           <s:element minOccurs="0" maxOccurs="1" name="HourValues" type="tns:ArrayOfAnyType" />
           <s:element minOccurs="0" maxOccurs="1" name="HourKeys" type="tns:ArrayOfAnyType" />
           <s:element minOccurs="0" maxOccurs="1" name="DayValues" type="tns:ArrayOfAnyType" />
           <s:element minOccurs="0" maxOccurs="1" name="DayKeys" type="tns:ArrayOfAnyType" />
           <s:element minOccurs="0" maxOccurs="1" name="MonthValues" type="tns:ArrayOfAnyType" />
           <s:element minOccurs="0" maxOccurs="1" name="MonthKeys" type="tns:ArrayOfAnyType" />
           <s:element minOccurs="0" maxOccurs="1" name="YearValues" type="tns:ArrayOfAnyType" />
           <s:element minOccurs="0" maxOccurs="1" name="YearKeys" type="tns:ArrayOfAnyType" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="ArrayOfAutoFilterDateNodeInfo">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="unbounded" name="AutoFilterDateNodeInfo" nillable="true" type="tns:AutoFilterDateNodeInfo" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="AutoFilterDateNodeInfo">
         <s:sequence>
           <s:element minOccurs="1" maxOccurs="1" name="NodeType" type="tns:DateNodeType" />
           <s:element minOccurs="1" maxOccurs="1" name="Year" type="s:short" />
           <s:element minOccurs="1" maxOccurs="1" name="Month" type="s:short" />
           <s:element minOccurs="1" maxOccurs="1" name="Day" type="s:short" />
           <s:element minOccurs="1" maxOccurs="1" name="Hour" type="s:short" />
           <s:element minOccurs="1" maxOccurs="1" name="Minute" type="s:short" />
           <s:element minOccurs="1" maxOccurs="1" name="Second" type="s:short" />
         </s:sequence>
       </s:complexType>
       <s:simpleType name="DateNodeType">
         <s:restriction base="s:string">
           <s:enumeration value="Nil" />
           <s:enumeration value="Year" />
           <s:enumeration value="Month" />
           <s:enumeration value="Day" />
           <s:enumeration value="Hour" />
           <s:enumeration value="Minute" />
           <s:enumeration value="Second" />
           <s:enumeration value="Max" />
         </s:restriction>
       </s:simpleType>
       <s:complexType name="ArrayOfAutoFilterItem">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="unbounded" name="AutoFilterItem" nillable="true" type="tns:AutoFilterItem" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="AutoFilterItem">
         <s:sequence>
           <s:element minOccurs="1" maxOccurs="1" name="Selected" type="s:boolean" />
           <s:element minOccurs="0" maxOccurs="1" name="DisplayString" type="s:string" />
         </s:sequence>
       </s:complexType>
       <s:element name="GetAutoFilterItemListResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="GetAutoFilterItemListResult" type="tns:AutoFilterItemList" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="GetPivotMenu">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="pivotFilterOptions" type="tns:PivotFilterOptions" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:complexType name="PivotFilterOptions">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="1" name="SheetName" type="s:string" />
           <s:element minOccurs="1" maxOccurs="1" name="SourceIndex" type="s:int" />
           <s:element minOccurs="1" maxOccurs="1" name="IsNamedObject" type="s:boolean" />
           <s:element minOccurs="0" maxOccurs="1" name="FieldId" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="DataFieldId" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="MemberPropertyId" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="FilterValue1" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="FilterValue2" type="s:string" />
           <s:element minOccurs="1" maxOccurs="1" name="FilterType" type="tns:PivotFilterType" />
           <s:element minOccurs="1" maxOccurs="1" name="ParentId" type="s:int" />
           <s:element minOccurs="1" maxOccurs="1" name="Column" type="s:int" />
           <s:element minOccurs="1" maxOccurs="1" name="Row" type="s:int" />
           <s:element minOccurs="0" maxOccurs="1" name="Items" type="tns:ArrayOfInt" />
         </s:sequence>
       </s:complexType>
       <s:simpleType name="PivotFilterType">
         <s:restriction base="s:string">
           <s:enumeration value="Invalid" />
           <s:enumeration value="FirstTop10" />
           <s:enumeration value="Count" />
           <s:enumeration value="Percent" />
           <s:enumeration value="Sum" />
           <s:enumeration value="LastTop10" />
           <s:enumeration value="CaptionFirst" />
           <s:enumeration value="CaptionEquals" />
           <s:enumeration value="CaptionDoesNotEqual" />
           <s:enumeration value="CaptionBeginsWith" />
           <s:enumeration value="CaptionDoesNotBeginWith" />
           <s:enumeration value="CaptionEndsWith" />
           <s:enumeration value="CaptionDoesNotEndWith" />
           <s:enumeration value="CaptionContains" />
           <s:enumeration value="CaptionDoesNotContain" />
           <s:enumeration value="CaptionIsGreaterThan" />
           <s:enumeration value="CaptionIsGreaterThanOrEqualTo" />
           <s:enumeration value="CaptionIsLessThan" />
           <s:enumeration value="CaptionIsLessThanOrEqualTo" />
           <s:enumeration value="CaptionIsBetween" />
           <s:enumeration value="CaptionIsNotBetween" />
           <s:enumeration value="ValueFirst" />
           <s:enumeration value="ValueEqual" />
           <s:enumeration value="ValueNotEqual" />
           <s:enumeration value="ValueGreaterThan" />
           <s:enumeration value="ValueGreaterThanOrEqual" />
           <s:enumeration value="ValueLessThan" />
           <s:enumeration value="ValueLessThanOrEqual" />
           <s:enumeration value="ValueBetween" />
           <s:enumeration value="ValueNotBetween" />
           <s:enumeration value="DateFirst" />
           <s:enumeration value="DateEquals" />
           <s:enumeration value="DateOlderThan" />
           <s:enumeration value="DateNewerThan" />
           <s:enumeration value="DateBetween" />
           <s:enumeration value="DateTomorrow" />
           <s:enumeration value="DateToday" />
           <s:enumeration value="DateYesterday" />
           <s:enumeration value="DateNextWeek" />
           <s:enumeration value="DateThisWeek" />
           <s:enumeration value="DateLastWeek" />
           <s:enumeration value="DateNextMonth" />
           <s:enumeration value="DateThisMonth" />
           <s:enumeration value="DateLastMonth" />
           <s:enumeration value="DateNextQuarter" />
           <s:enumeration value="DateThisQuarter" />
           <s:enumeration value="DateLastQuarter" />
           <s:enumeration value="DateNextYear" />
           <s:enumeration value="DateThisYear" />
           <s:enumeration value="DateLastYear" />
           <s:enumeration value="DateYearToDate" />
           <s:enumeration value="DateAllDatesInPeriodQuarter1" />
           <s:enumeration value="DateAllDatesInPeriodQuarter2" />
           <s:enumeration value="DateAllDatesInPeriodQuarter3" />
           <s:enumeration value="DateAllDatesInPeriodQuarter4" />
           <s:enumeration value="DateAllDatesInPeriodJanuary" />
           <s:enumeration value="DateAllDatesInPeriodFebruary" />
           <s:enumeration value="DateAllDatesInPeriodMarch" />
           <s:enumeration value="DateAllDatesInPeriodApril" />
           <s:enumeration value="DateAllDatesInPeriodMay" />
           <s:enumeration value="DateAllDatesInPeriodJune" />
           <s:enumeration value="DateAllDatesInPeriodJuly" />
           <s:enumeration value="DateAllDatesInPeriodAugust" />
           <s:enumeration value="DateAllDatesInPeriodSeptember" />
           <s:enumeration value="DateAllDatesInPeriodOctober" />
           <s:enumeration value="DateAllDatesInPeriodNovember" />
           <s:enumeration value="DateAllDatesInPeriodDecember" />
           <s:enumeration value="DateNotEqual" />
           <s:enumeration value="DateOlderOrEqual" />
           <s:enumeration value="DateNewerOrEqual" />
           <s:enumeration value="DateNotBetween" />
           <s:enumeration value="Last" />
         </s:restriction>
       </s:simpleType>
       <s:complexType name="ArrayOfInt">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="unbounded" name="int" type="s:int" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="PivotMenu">
         <s:sequence>
           <s:element minOccurs="1" maxOccurs="1" name="Top10MaxItems" type="s:int" />
           <s:element minOccurs="1" maxOccurs="1" name="AdvancedFiltering" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="IsPageFilter" type="s:boolean" />
           <s:element minOccurs="0" maxOccurs="1" name="PivotDataFields" type="tns:ArrayOfPivotField" />
           <s:element minOccurs="0" maxOccurs="1" name="PivotFields" type="tns:ArrayOfPivotField" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="ArrayOfPivotField">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="unbounded" name="PivotField" nillable="true" type="tns:PivotField" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="PivotField">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="1" name="MemberProperties" type="tns:ArrayOfPivotField" />
           <s:element minOccurs="0" maxOccurs="1" name="PivotFilterParameters" type="tns:ArrayOfPivotFilterParameter" />
           <s:element minOccurs="1" maxOccurs="1" name="IsNonnumericCaptionFilteringEnabled" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="IsDateFilteringEnabled" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="IsCaptionFilteringEnabled" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="IsFilteringEnabled" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="IsDateField" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="IsDataField" type="s:boolean" />
           <s:element minOccurs="0" maxOccurs="1" name="FilterParameter" type="tns:Top10FilterParameter" />
           <s:element minOccurs="1" maxOccurs="1" name="IsSortedDescending" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="IsSortedAscending" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="HasCustomFilter" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="HasManualFilter" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="HasTop10Filter" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="IsHierarchy" type="s:boolean" />
           <s:element minOccurs="0" maxOccurs="1" name="IdString" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="DisplayString" type="s:string" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="ArrayOfPivotFilterParameter">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="unbounded" name="PivotFilterParameter" nillable="true" type="tns:PivotFilterParameter" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="PivotFilterParameter">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="1" name="FilterString2" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="FilterString1" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="MemberPropertyId" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="DataFieldId" type="s:string" />
           <s:element minOccurs="1" maxOccurs="1" name="FilterType" type="tns:PivotFilterType" />
           <s:element minOccurs="1" maxOccurs="1" name="FilterValue2" type="s:double" />
           <s:element minOccurs="1" maxOccurs="1" name="FilterValue1" type="s:double" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="Top10FilterParameter">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="1" name="DataFieldId" type="s:string" />
           <s:element minOccurs="1" maxOccurs="1" name="FilterType" type="tns:Top10FilterType" />
           <s:element minOccurs="1" maxOccurs="1" name="FilterValue" type="s:double" />
           <s:element minOccurs="1" maxOccurs="1" name="IsTopFilter" type="s:boolean" />
         </s:sequence>
       </s:complexType>
       <s:simpleType name="Top10FilterType">
         <s:restriction base="s:string">
           <s:enumeration value="Invalid" />
           <s:enumeration value="Count" />
           <s:enumeration value="Percent" />
           <s:enumeration value="Sum" />
         </s:restriction>
       </s:simpleType>
       <s:element name="GetPivotMenuResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="GetPivotMenuResult" type="tns:CommandResult" />
             <s:element minOccurs="0" maxOccurs="1" name="pivotMenu" type="tns:PivotMenu" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="GetPivotFilterItemList">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="pivotFilterOptions" type="tns:PivotFilterOptions" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:complexType name="PivotFilterItemList">
         <s:sequence>
           <s:element minOccurs="1" maxOccurs="1" name="ItemListMaxExceeded" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="IsBlanksSelected" type="s:boolean" />
           <s:element minOccurs="1" maxOccurs="1" name="HasBlanks" type="s:boolean" />
           <s:element minOccurs="0" maxOccurs="1" name="PivotFilterItems" type="tns:ArrayOfPivotFilterItem" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="ArrayOfPivotFilterItem">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="unbounded" name="PivotFilterItem" nillable="true" type="tns:PivotFilterItem" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="PivotFilterItem" mixed="false">
         <s:complexContent mixed="false">
           <s:extension base="tns:PivotFilterItemList">
             <s:sequence>
               <s:element minOccurs="0" maxOccurs="1" name="ChildItems" type="tns:ArrayOfPivotFilterItem" />
               <s:element minOccurs="1" maxOccurs="1" name="CalculatedMember" type="s:boolean" />
               <s:element minOccurs="1" maxOccurs="1" name="LeafItem" type="s:boolean" />
               <s:element minOccurs="1" maxOccurs="1" name="Selected" type="s:boolean" />
               <s:element minOccurs="1" maxOccurs="1" name="Id" type="s:int" />
               <s:element minOccurs="0" maxOccurs="1" name="DisplayString" type="s:string" />
             </s:sequence>
           </s:extension>
         </s:complexContent>
       </s:complexType>
       <s:element name="GetPivotFilterItemListResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="GetPivotFilterItemListResult" type="tns:CommandResult" />
             <s:element minOccurs="0" maxOccurs="1" name="itemList" type="tns:PivotFilterItemList" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="ConnectAndGetPivotFilterItemList">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="pivotFilterOptions" type="tns:PivotFilterOptions" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="ConnectAndGetPivotFilterItemListResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="ConnectAndGetPivotFilterItemListResult" type="tns:CommandResult" />
             <s:element minOccurs="0" maxOccurs="1" name="itemList" type="tns:PivotFilterItemList" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="GetWorkbook">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="1" maxOccurs="1" name="workbookType" type="tns:WorkbookType" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:simpleType name="WorkbookType">
         <s:restriction base="s:string">
           <s:enumeration value="FullWorkbook" />
           <s:enumeration value="FullSnapshot" />
           <s:enumeration value="PublishedItemsSnapshot" />
         </s:restriction>
       </s:simpleType>
       <s:element name="GetWorkbookResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="GetWorkbookResult" type="s:base64Binary" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="GetImage">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="imageId" type="s:string" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="GetImageResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="GetImageResult" type="tns:CommandResult" />
             <s:element minOccurs="0" maxOccurs="1" name="imageFormatType" type="s:string" />
             <s:element minOccurs="0" maxOccurs="1" name="binaryChartImage" type="s:base64Binary" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="OpenWorkbook">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="url" type="s:string" />
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="cultureParameter" type="tns:CultureCommandParameter" />
             <s:element minOccurs="1" maxOccurs="1" name="requestSiteId" type="s1:guid" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:complexType name="CultureCommandParameter">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="1" name="UICultureName" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="DataCultureName" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="SharePointDataCultureName" type="s:string" />
           <s:element minOccurs="0" maxOccurs="1" name="TimeZoneSerialization" type="s:string" />
         </s:sequence>
       </s:complexType>
       <s:element name="OpenWorkbookResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="OpenWorkbookResult" type="tns:CommandResult" />
             <s:element minOccurs="0" maxOccurs="1" name="workbookId" type="s:string" />
             <s:element minOccurs="1" maxOccurs="1" name="hasOpenItemPermission" type="s:boolean" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="SetRange">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="sheetRange" type="tns:SheetRange" />
             <s:element minOccurs="0" maxOccurs="1" name="cellsArray" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="SetRangeResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="SetRangeResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="SetRangeA1">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="sheetName" type="s:string" />
             <s:element minOccurs="0" maxOccurs="1" name="range" type="s:string" />
             <s:element minOccurs="0" maxOccurs="1" name="cellsArray" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="SetRangeA1Response">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="SetRangeA1Result" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="SetParameters">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="workbookParameters" type="tns:ArrayOfWorkbookParameter" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:complexType name="ArrayOfWorkbookParameter">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="unbounded" name="WorkbookParameter" nillable="true" type="tns:WorkbookParameter" />
         </s:sequence>
       </s:complexType>
       <s:complexType name="WorkbookParameter">
         <s:sequence>
           <s:element minOccurs="0" maxOccurs="1" name="Comment" type="s:string" />
           <s:element minOccurs="1" maxOccurs="1" name="IsPivotPageField" type="s:boolean" />
           <s:element minOccurs="0" maxOccurs="1" name="Name" type="s:string" />
           <s:element minOccurs="1" maxOccurs="1" name="RequiresConnection" type="s:boolean" />
           <s:element minOccurs="0" maxOccurs="1" name="Values" type="tns:ArrayOfString" />
         </s:sequence>
       </s:complexType>
       <s:element name="SetParametersResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="SetParametersResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="Refresh">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="dataConnectionName" type="s:string" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="RefreshResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="RefreshResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="RefreshAll">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="1" maxOccurs="1" name="periodic" type="s:boolean" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="RefreshAllResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="RefreshAllResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="RecalcAll">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="1" maxOccurs="1" name="calculateType" type="tns:CalculateType" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:simpleType name="CalculateType">
         <s:restriction base="s:string">
           <s:enumeration value="Recalculate" />
           <s:enumeration value="CalculateFull" />
         </s:restriction>
       </s:simpleType>
       <s:element name="RecalcAllResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="RecalcAllResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="Recalc">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="sheetRange" type="tns:SheetRange" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="RecalcResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="RecalcResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="RecalcA1">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="sheetName" type="s:string" />
             <s:element minOccurs="0" maxOccurs="1" name="rangeName" type="s:string" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="RecalcA1Response">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="RecalcA1Result" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="ApplyTop10Filter">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="autoFilterOptions" type="tns:AutoFilterOptions" />
             <s:element minOccurs="1" maxOccurs="1" name="top" type="s:boolean" />
             <s:element minOccurs="1" maxOccurs="1" name="percent" type="s:boolean" />
             <s:element minOccurs="1" maxOccurs="1" name="value" type="s:int" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="ApplyTop10FilterResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="ApplyTop10FilterResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="ApplyItemFilter">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="autoFilterOptions" type="tns:AutoFilterOptions" />
             <s:element minOccurs="0" maxOccurs="1" name="values" type="tns:ArrayOfString" />
             <s:element minOccurs="0" maxOccurs="1" name="autoFilterDateNodes" type="tns:ArrayOfAutoFilterDateNodeInfo" />
             <s:element minOccurs="1" maxOccurs="1" name="blanks" type="s:boolean" />
             <s:element minOccurs="1" maxOccurs="1" name="hideBlanks" type="s:boolean" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="ApplyItemFilterResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="ApplyItemFilterResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="SortFilterColumn">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="autoFilterOptions" type="tns:AutoFilterOptions" />
             <s:element minOccurs="1" maxOccurs="1" name="ascending" type="s:boolean" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="SortFilterColumnResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="SortFilterColumnResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="ApplyPivotFilter">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="pivotFilterOptions" type="tns:PivotFilterOptions" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="ApplyPivotFilterResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="ApplyPivotFilterResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="ApplyPivotTop10Filter">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="pivotFilterOptions" type="tns:PivotFilterOptions" />
             <s:element minOccurs="1" maxOccurs="1" name="top" type="s:boolean" />
             <s:element minOccurs="1" maxOccurs="1" name="value" type="s:double" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="ApplyPivotTop10FilterResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="ApplyPivotTop10FilterResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="ApplyPivotSort">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="pivotFilterOptions" type="tns:PivotFilterOptions" />
             <s:element minOccurs="1" maxOccurs="1" name="ascending" type="s:boolean" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="ApplyPivotSortResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="ApplyPivotSortResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="TogglePivotDrill">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="pivotFilterOptions" type="tns:PivotFilterOptions" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="TogglePivotDrillResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="TogglePivotDrillResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="RemovePivotFilter">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="pivotFilterOptions" type="tns:PivotFilterOptions" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="RemovePivotFilterResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="RemovePivotFilterResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="ExpandCollapseOutline">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="parameter" type="tns:CommandParameter" />
             <s:element minOccurs="0" maxOccurs="1" name="sheetName" type="s:string" />
             <s:element minOccurs="1" maxOccurs="1" name="outlineLevel" type="s:unsignedByte" />
             <s:element minOccurs="1" maxOccurs="1" name="rowColumn" type="s:int" />
             <s:element minOccurs="1" maxOccurs="1" name="row" type="s:boolean" />
           </s:sequence>
         </s:complexType>
       </s:element>
       <s:element name="ExpandCollapseOutlineResponse">
         <s:complexType>
           <s:sequence>
             <s:element minOccurs="0" maxOccurs="1" name="ExpandCollapseOutlineResult" type="tns:CommandResult" />
           </s:sequence>
         </s:complexType>
       </s:element>
     </s:schema>
     <s:schema elementFormDefault="qualified" targetNamespace="http://microsoft.com/wsdl/types/">
       <s:simpleType name="guid">
         <s:restriction base="s:string">
           <s:pattern value="[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}" />
         </s:restriction>
       </s:simpleType>
     </s:schema>
   </wsdl:types>
   <wsdl:message name="CloseWorkbookSoapIn">
     <wsdl:part name="parameters" element="tns:CloseWorkbook" />
   </wsdl:message>
   <wsdl:message name="CloseWorkbookSoapOut">
     <wsdl:part name="parameters" element="tns:CloseWorkbookResponse" />
   </wsdl:message>
   <wsdl:message name="GetRangeSoapIn">
     <wsdl:part name="parameters" element="tns:GetRange" />
   </wsdl:message>
   <wsdl:message name="GetRangeSoapOut">
     <wsdl:part name="parameters" element="tns:GetRangeResponse" />
   </wsdl:message>
   <wsdl:message name="GetRangeValuesSoapIn">
     <wsdl:part name="parameters" element="tns:GetRangeValues" />
   </wsdl:message>
   <wsdl:message name="GetRangeValuesSoapOut">
     <wsdl:part name="parameters" element="tns:GetRangeValuesResponse" />
   </wsdl:message>
   <wsdl:message name="GetRangeValuesA1SoapIn">
     <wsdl:part name="parameters" element="tns:GetRangeValuesA1" />
   </wsdl:message>
   <wsdl:message name="GetRangeValuesA1SoapOut">
     <wsdl:part name="parameters" element="tns:GetRangeValuesA1Response" />
   </wsdl:message>
   <wsdl:message name="CancelRequestSoapIn">
     <wsdl:part name="parameters" element="tns:CancelRequest" />
   </wsdl:message>
   <wsdl:message name="CancelRequestSoapOut">
     <wsdl:part name="parameters" element="tns:CancelRequestResponse" />
   </wsdl:message>
   <wsdl:message name="GetSessionInformationSoapIn">
     <wsdl:part name="parameters" element="tns:GetSessionInformation" />
   </wsdl:message>
   <wsdl:message name="GetSessionInformationSoapOut">
     <wsdl:part name="parameters" element="tns:GetSessionInformationResponse" />
   </wsdl:message>
   <wsdl:message name="FindRangeSoapIn">
     <wsdl:part name="parameters" element="tns:FindRange" />
   </wsdl:message>
   <wsdl:message name="FindRangeSoapOut">
     <wsdl:part name="parameters" element="tns:FindRangeResponse" />
   </wsdl:message>
   <wsdl:message name="GetAutoFilterItemListSoapIn">
     <wsdl:part name="parameters" element="tns:GetAutoFilterItemList" />
   </wsdl:message>
   <wsdl:message name="GetAutoFilterItemListSoapOut">
     <wsdl:part name="parameters" element="tns:GetAutoFilterItemListResponse" />
   </wsdl:message>
   <wsdl:message name="GetPivotMenuSoapIn">
     <wsdl:part name="parameters" element="tns:GetPivotMenu" />
   </wsdl:message>
   <wsdl:message name="GetPivotMenuSoapOut">
     <wsdl:part name="parameters" element="tns:GetPivotMenuResponse" />
   </wsdl:message>
   <wsdl:message name="GetPivotFilterItemListSoapIn">
     <wsdl:part name="parameters" element="tns:GetPivotFilterItemList" />
   </wsdl:message>
   <wsdl:message name="GetPivotFilterItemListSoapOut">
     <wsdl:part name="parameters" element="tns:GetPivotFilterItemListResponse" />
   </wsdl:message>
   <wsdl:message name="ConnectAndGetPivotFilterItemListSoapIn">
     <wsdl:part name="parameters" element="tns:ConnectAndGetPivotFilterItemList" />
   </wsdl:message>
   <wsdl:message name="ConnectAndGetPivotFilterItemListSoapOut">
     <wsdl:part name="parameters" element="tns:ConnectAndGetPivotFilterItemListResponse" />
   </wsdl:message>
   <wsdl:message name="GetWorkbookSoapIn">
     <wsdl:part name="parameters" element="tns:GetWorkbook" />
   </wsdl:message>
   <wsdl:message name="GetWorkbookSoapOut">
     <wsdl:part name="parameters" element="tns:GetWorkbookResponse" />
   </wsdl:message>
   <wsdl:message name="GetImageSoapIn">
     <wsdl:part name="parameters" element="tns:GetImage" />
   </wsdl:message>
   <wsdl:message name="GetImageSoapOut">
     <wsdl:part name="parameters" element="tns:GetImageResponse" />
   </wsdl:message>
   <wsdl:message name="OpenWorkbookSoapIn">
     <wsdl:part name="parameters" element="tns:OpenWorkbook" />
   </wsdl:message>
   <wsdl:message name="OpenWorkbookSoapOut">
     <wsdl:part name="parameters" element="tns:OpenWorkbookResponse" />
   </wsdl:message>
   <wsdl:message name="SetRangeSoapIn">
     <wsdl:part name="parameters" element="tns:SetRange" />
   </wsdl:message>
   <wsdl:message name="SetRangeSoapOut">
     <wsdl:part name="parameters" element="tns:SetRangeResponse" />
   </wsdl:message>
   <wsdl:message name="SetRangeA1SoapIn">
     <wsdl:part name="parameters" element="tns:SetRangeA1" />
   </wsdl:message>
   <wsdl:message name="SetRangeA1SoapOut">
     <wsdl:part name="parameters" element="tns:SetRangeA1Response" />
   </wsdl:message>
   <wsdl:message name="SetParametersSoapIn">
     <wsdl:part name="parameters" element="tns:SetParameters" />
   </wsdl:message>
   <wsdl:message name="SetParametersSoapOut">
     <wsdl:part name="parameters" element="tns:SetParametersResponse" />
   </wsdl:message>
   <wsdl:message name="RefreshSoapIn">
     <wsdl:part name="parameters" element="tns:Refresh" />
   </wsdl:message>
   <wsdl:message name="RefreshSoapOut">
     <wsdl:part name="parameters" element="tns:RefreshResponse" />
   </wsdl:message>
   <wsdl:message name="RefreshAllSoapIn">
     <wsdl:part name="parameters" element="tns:RefreshAll" />
   </wsdl:message>
   <wsdl:message name="RefreshAllSoapOut">
     <wsdl:part name="parameters" element="tns:RefreshAllResponse" />
   </wsdl:message>
   <wsdl:message name="RecalcAllSoapIn">
     <wsdl:part name="parameters" element="tns:RecalcAll" />
   </wsdl:message>
   <wsdl:message name="RecalcAllSoapOut">
     <wsdl:part name="parameters" element="tns:RecalcAllResponse" />
   </wsdl:message>
   <wsdl:message name="RecalcSoapIn">
     <wsdl:part name="parameters" element="tns:Recalc" />
   </wsdl:message>
   <wsdl:message name="RecalcSoapOut">
     <wsdl:part name="parameters" element="tns:RecalcResponse" />
   </wsdl:message>
   <wsdl:message name="RecalcA1SoapIn">
     <wsdl:part name="parameters" element="tns:RecalcA1" />
   </wsdl:message>
   <wsdl:message name="RecalcA1SoapOut">
     <wsdl:part name="parameters" element="tns:RecalcA1Response" />
   </wsdl:message>
   <wsdl:message name="ApplyTop10FilterSoapIn">
     <wsdl:part name="parameters" element="tns:ApplyTop10Filter" />
   </wsdl:message>
   <wsdl:message name="ApplyTop10FilterSoapOut">
     <wsdl:part name="parameters" element="tns:ApplyTop10FilterResponse" />
   </wsdl:message>
   <wsdl:message name="ApplyItemFilterSoapIn">
     <wsdl:part name="parameters" element="tns:ApplyItemFilter" />
   </wsdl:message>
   <wsdl:message name="ApplyItemFilterSoapOut">
     <wsdl:part name="parameters" element="tns:ApplyItemFilterResponse" />
   </wsdl:message>
   <wsdl:message name="SortFilterColumnSoapIn">
     <wsdl:part name="parameters" element="tns:SortFilterColumn" />
   </wsdl:message>
   <wsdl:message name="SortFilterColumnSoapOut">
     <wsdl:part name="parameters" element="tns:SortFilterColumnResponse" />
   </wsdl:message>
   <wsdl:message name="ApplyPivotFilterSoapIn">
     <wsdl:part name="parameters" element="tns:ApplyPivotFilter" />
   </wsdl:message>
   <wsdl:message name="ApplyPivotFilterSoapOut">
     <wsdl:part name="parameters" element="tns:ApplyPivotFilterResponse" />
   </wsdl:message>
   <wsdl:message name="ApplyPivotTop10FilterSoapIn">
     <wsdl:part name="parameters" element="tns:ApplyPivotTop10Filter" />
   </wsdl:message>
   <wsdl:message name="ApplyPivotTop10FilterSoapOut">
     <wsdl:part name="parameters" element="tns:ApplyPivotTop10FilterResponse" />
   </wsdl:message>
   <wsdl:message name="ApplyPivotSortSoapIn">
     <wsdl:part name="parameters" element="tns:ApplyPivotSort" />
   </wsdl:message>
   <wsdl:message name="ApplyPivotSortSoapOut">
     <wsdl:part name="parameters" element="tns:ApplyPivotSortResponse" />
   </wsdl:message>
   <wsdl:message name="TogglePivotDrillSoapIn">
     <wsdl:part name="parameters" element="tns:TogglePivotDrill" />
   </wsdl:message>
   <wsdl:message name="TogglePivotDrillSoapOut">
     <wsdl:part name="parameters" element="tns:TogglePivotDrillResponse" />
   </wsdl:message>
   <wsdl:message name="RemovePivotFilterSoapIn">
     <wsdl:part name="parameters" element="tns:RemovePivotFilter" />
   </wsdl:message>
   <wsdl:message name="RemovePivotFilterSoapOut">
     <wsdl:part name="parameters" element="tns:RemovePivotFilterResponse" />
   </wsdl:message>
   <wsdl:message name="ExpandCollapseOutlineSoapIn">
     <wsdl:part name="parameters" element="tns:ExpandCollapseOutline" />
   </wsdl:message>
   <wsdl:message name="ExpandCollapseOutlineSoapOut">
     <wsdl:part name="parameters" element="tns:ExpandCollapseOutlineResponse" />
   </wsdl:message>
   <wsdl:portType name="ExcelServiceSoapSoap">
     <wsdl:operation name="CloseWorkbook">
       <wsdl:input message="tns:CloseWorkbookSoapIn" />
       <wsdl:output message="tns:CloseWorkbookSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="GetRange">
       <wsdl:input message="tns:GetRangeSoapIn" />
       <wsdl:output message="tns:GetRangeSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="GetRangeValues">
       <wsdl:input message="tns:GetRangeValuesSoapIn" />
       <wsdl:output message="tns:GetRangeValuesSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="GetRangeValuesA1">
       <wsdl:input message="tns:GetRangeValuesA1SoapIn" />
       <wsdl:output message="tns:GetRangeValuesA1SoapOut" />
     </wsdl:operation>
     <wsdl:operation name="CancelRequest">
       <wsdl:input message="tns:CancelRequestSoapIn" />
       <wsdl:output message="tns:CancelRequestSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="GetSessionInformation">
       <wsdl:input message="tns:GetSessionInformationSoapIn" />
       <wsdl:output message="tns:GetSessionInformationSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="FindRange">
       <wsdl:input message="tns:FindRangeSoapIn" />
       <wsdl:output message="tns:FindRangeSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="GetAutoFilterItemList">
       <wsdl:input message="tns:GetAutoFilterItemListSoapIn" />
       <wsdl:output message="tns:GetAutoFilterItemListSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="GetPivotMenu">
       <wsdl:input message="tns:GetPivotMenuSoapIn" />
       <wsdl:output message="tns:GetPivotMenuSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="GetPivotFilterItemList">
       <wsdl:input message="tns:GetPivotFilterItemListSoapIn" />
       <wsdl:output message="tns:GetPivotFilterItemListSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="ConnectAndGetPivotFilterItemList">
       <wsdl:input message="tns:ConnectAndGetPivotFilterItemListSoapIn" />
       <wsdl:output message="tns:ConnectAndGetPivotFilterItemListSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="GetWorkbook">
       <wsdl:input message="tns:GetWorkbookSoapIn" />
       <wsdl:output message="tns:GetWorkbookSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="GetImage">
       <wsdl:input message="tns:GetImageSoapIn" />
       <wsdl:output message="tns:GetImageSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="OpenWorkbook">
       <wsdl:input message="tns:OpenWorkbookSoapIn" />
       <wsdl:output message="tns:OpenWorkbookSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="SetRange">
       <wsdl:input message="tns:SetRangeSoapIn" />
       <wsdl:output message="tns:SetRangeSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="SetRangeA1">
       <wsdl:input message="tns:SetRangeA1SoapIn" />
       <wsdl:output message="tns:SetRangeA1SoapOut" />
     </wsdl:operation>
     <wsdl:operation name="SetParameters">
       <wsdl:input message="tns:SetParametersSoapIn" />
       <wsdl:output message="tns:SetParametersSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="Refresh">
       <wsdl:input message="tns:RefreshSoapIn" />
       <wsdl:output message="tns:RefreshSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="RefreshAll">
       <wsdl:input message="tns:RefreshAllSoapIn" />
       <wsdl:output message="tns:RefreshAllSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="RecalcAll">
       <wsdl:input message="tns:RecalcAllSoapIn" />
       <wsdl:output message="tns:RecalcAllSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="Recalc">
       <wsdl:input message="tns:RecalcSoapIn" />
       <wsdl:output message="tns:RecalcSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="RecalcA1">
       <wsdl:input message="tns:RecalcA1SoapIn" />
       <wsdl:output message="tns:RecalcA1SoapOut" />
     </wsdl:operation>
     <wsdl:operation name="ApplyTop10Filter">
       <wsdl:input message="tns:ApplyTop10FilterSoapIn" />
       <wsdl:output message="tns:ApplyTop10FilterSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="ApplyItemFilter">
       <wsdl:input message="tns:ApplyItemFilterSoapIn" />
       <wsdl:output message="tns:ApplyItemFilterSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="SortFilterColumn">
       <wsdl:input message="tns:SortFilterColumnSoapIn" />
       <wsdl:output message="tns:SortFilterColumnSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="ApplyPivotFilter">
       <wsdl:input message="tns:ApplyPivotFilterSoapIn" />
       <wsdl:output message="tns:ApplyPivotFilterSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="ApplyPivotTop10Filter">
       <wsdl:input message="tns:ApplyPivotTop10FilterSoapIn" />
       <wsdl:output message="tns:ApplyPivotTop10FilterSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="ApplyPivotSort">
       <wsdl:input message="tns:ApplyPivotSortSoapIn" />
       <wsdl:output message="tns:ApplyPivotSortSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="TogglePivotDrill">
       <wsdl:input message="tns:TogglePivotDrillSoapIn" />
       <wsdl:output message="tns:TogglePivotDrillSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="RemovePivotFilter">
       <wsdl:input message="tns:RemovePivotFilterSoapIn" />
       <wsdl:output message="tns:RemovePivotFilterSoapOut" />
     </wsdl:operation>
     <wsdl:operation name="ExpandCollapseOutline">
       <wsdl:input message="tns:ExpandCollapseOutlineSoapIn" />
       <wsdl:output message="tns:ExpandCollapseOutlineSoapOut" />
     </wsdl:operation>
   </wsdl:portType>
   <wsdl:binding name="ExcelServiceSoapSoap" type="tns:ExcelServiceSoapSoap">
     <soap:binding transport="http://schemas.xmlsoap.org/soap/http" />
     <wsdl:operation name="CloseWorkbook">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/CloseWorkbook" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetRange">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetRange" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetRangeValues">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetRangeValues" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetRangeValuesA1">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetRangeValuesA1" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="CancelRequest">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/CancelRequest" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetSessionInformation">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetSessionInformation" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="FindRange">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/FindRange" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetAutoFilterItemList">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetAutoFilterItemList" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetPivotMenu">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetPivotMenu" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetPivotFilterItemList">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetPivotFilterItemList" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="ConnectAndGetPivotFilterItemList">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ConnectAndGetPivotFilterItemList" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetWorkbook">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetWorkbook" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetImage">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetImage" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="OpenWorkbook">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/OpenWorkbook" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="SetRange">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/SetRange" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="SetRangeA1">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/SetRangeA1" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="SetParameters">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/SetParameters" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="Refresh">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/Refresh" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="RefreshAll">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/RefreshAll" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="RecalcAll">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/RecalcAll" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="Recalc">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/Recalc" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="RecalcA1">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/RecalcA1" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="ApplyTop10Filter">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ApplyTop10Filter" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="ApplyItemFilter">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ApplyItemFilter" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="SortFilterColumn">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/SortFilterColumn" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="ApplyPivotFilter">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ApplyPivotFilter" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="ApplyPivotTop10Filter">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ApplyPivotTop10Filter" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="ApplyPivotSort">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ApplyPivotSort" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="TogglePivotDrill">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/TogglePivotDrill" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="RemovePivotFilter">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/RemovePivotFilter" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="ExpandCollapseOutline">
       <soap:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExpandCollapseOutline" style="document" />
       <wsdl:input>
         <soap:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
   </wsdl:binding>
   <wsdl:binding name="ExcelServiceSoapSoap12" type="tns:ExcelServiceSoapSoap">
     <soap12:binding transport="http://schemas.xmlsoap.org/soap/http" />
     <wsdl:operation name="CloseWorkbook">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/CloseWorkbook" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetRange">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetRange" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetRangeValues">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetRangeValues" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetRangeValuesA1">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetRangeValuesA1" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="CancelRequest">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/CancelRequest" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetSessionInformation">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetSessionInformation" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="FindRange">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/FindRange" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetAutoFilterItemList">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetAutoFilterItemList" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetPivotMenu">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetPivotMenu" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetPivotFilterItemList">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetPivotFilterItemList" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="ConnectAndGetPivotFilterItemList">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ConnectAndGetPivotFilterItemList" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetWorkbook">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetWorkbook" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="GetImage">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/GetImage" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="OpenWorkbook">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/OpenWorkbook" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="SetRange">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/SetRange" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="SetRangeA1">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/SetRangeA1" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="SetParameters">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/SetParameters" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="Refresh">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/Refresh" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="RefreshAll">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/RefreshAll" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="RecalcAll">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/RecalcAll" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="Recalc">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/Recalc" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="RecalcA1">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/RecalcA1" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="ApplyTop10Filter">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ApplyTop10Filter" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="ApplyItemFilter">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ApplyItemFilter" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="SortFilterColumn">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/SortFilterColumn" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="ApplyPivotFilter">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ApplyPivotFilter" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="ApplyPivotTop10Filter">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ApplyPivotTop10Filter" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="ApplyPivotSort">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ApplyPivotSort" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="TogglePivotDrill">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/TogglePivotDrill" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="RemovePivotFilter">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/RemovePivotFilter" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
     <wsdl:operation name="ExpandCollapseOutline">
       <soap12:operation soapAction="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExpandCollapseOutline" style="document" />
       <wsdl:input>
         <soap12:body use="literal" />
       </wsdl:input>
       <wsdl:output>
         <soap12:body use="literal" />
       </wsdl:output>
     </wsdl:operation>
   </wsdl:binding>
 </wsdl:definitions>
Show: