Revision Summary Date Revision History Revision Class Comments 4/4/2008 0.1 New Initial Availability 6/27/2008 1.0 Revised and edited technical content 10/6/2008 1.01 Minor Revised and edited technical content 12/12/2008 1.02 Minor Revised and edited technical content 7/13/2009 1.03 Major Revised and edited the technical content 8/28/2009 1.04 Editorial Revised and edited the technical content 11/6/2009 1.05 Editorial Revised and edited the technical content 2/19/2010 2.0 Updated the technical content 3/31/2010 2.01 Editorial Revised and edited the technical content 4/30/2010 2.02 Editorial Revised and edited the technical content 6/7/2010 2.03 Editorial Revised and edited the technical content 6/29/2010 2.04 Editorial Changed language and formatting in the
1/20/2012 3.0 Major Significantly changed the technical content. 4/11/2012 3.0 None No changes to the meaning, language, or formatting of the technical content. 7/16/2012 3.0 None No changes to the meaning, language, or formatting of the technical content. 9/12/2012 3.0 None No changes to the meaning, language, or formatting of the technical content. 10/8/2012 3.0.1 Editorial Changed language and formatting in the technical content. 2/11/2013 3.0.1 None No changes to the meaning, language, or formatting of the technical content. 7/30/2013 3.0.1 None No changes to the meaning, language, or formatting of the
technical content. 11/18/2013 3.1 Minor Clarified the meaning of the technical content. 2/10/2014 3.1 None No changes to the meaning, language, or formatting of the technical content. 4/30/2014 3.2 Clarified the meaning of the technical content. 7/31/2014 3.3 Minor Clarified the meaning of the technical content. 10/30/2014 3.3 None No changes to the meaning, language, or formatting of the technical content. 2/26/2016 4.0 Major Significantly changed the technical content. 7/15/2016 4.0 None No changes to the meaning, language, or formatting of the technical content. 9/14/2016 4.0 None No changes to the meaning, language, or
of the in a workbook. GetRange This operation is used to retrieve the contents of a specific range in the workbook. GetRangeA1 This operation is used to retrieve the contents of a in the workbook. GetSessionInformation This operation retrieves information about a session (2) on the protocol server. GetSheetNames The operation returns information about the in a workbook. GetWorkbook This operation is used to retrieve a workbook file. GetWorkbookConnections Returns a list of names in the workbook. NewWorkbook This operation is used to create a . OpenWorkbook This operation is used to create a new , giving access to a workbook
The contains the GetApiVersionResponse element. Elements The following table summarizes the element definitions that are specific to this operation. Element Description GetApiVersion The input data for the GetApiVersion . GetApiVersionResponse The result data for the GetApiVersion WSDL operation. GetApiVersion The GetApiVersion element specifies the input data for the GetApiVersion . <xs:element name="GetApiVersion" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:complexType/> </xs:element> GetApiVersionResponse The GetApiVersionResponse element specifies the result data for the GetApiVersion . <xs:element name="GetApiVersionResponse" <xs:complexType> <xs:sequence> <xs:element minOccurs="0" maxOccurs="1" name="GetApiVersionResult" type="xs:string"/> <xs:element minOccurs="0" maxOccurs="1" name="status" type="tns:ArrayOfStatus"/> </xs:sequence> </xs:complexType> </xs:element> GetApiVersionResult: The version of the server. MUST be present. status: MUST NOT be present. Complex Types None. Simple Types None. Attributes None. Groups None.
DetailedRefreshResult Namespace: http://schemas.microsoft.com/office/excel/server/webservices MUST NOT be used. <xs:complexType name="DetailedRefreshResult" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:sequence> <xs:element minOccurs="0" maxOccurs="1" name="ConnectionName" type="xs:string"/> <xs:element minOccurs="0" maxOccurs="1" name="ErrorMessage" type="xs:string"/> </xs:sequence> </xs:complexType> ConnectionName: MUST NOT be used. ErrorMessage: MUST NOT be used. Simple Types None. Attributes None. Groups None. Attribute Groups None. RefreshEx This operation is used to on a . The following is the port type specification of the RefreshEx . <wsdl:operation name="RefreshEx" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"> message="tns:RefreshExSoapIn"/> <wsdl:output message="tns:RefreshExSoapOut"/> </wsdl:operation> For details, see the Refresh operation (section ). Messages The following table summarizes the set of definitions that are specific to this operation. Message Description RefreshExSoapIn The request WSDL message for the RefreshEx . RefreshExSoapOut The response WSDL message for the RefreshEx WSDL operation.
status: An array of status information as specified in section . Complex Types None. Simple Types None. Attributes None. Groups None. Attribute Groups None. SetRangeA1 This operation is used to set values to a of on a . The following is the port type specification of the SetRangeA1 . <wsdl:operation name="SetRangeA1" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"> <wsdl:input message="tns:SetRangeA1SoapIn"/> <wsdl:output message="tns:SetRangeA1SoapOut"/> </wsdl:operation> The that contains the range that will be set is determined in the following manner: If rangeName specifies a sheet (2), that sheet (2) MUST be used. Otherwise, the sheet (2) specified in sheetName MUST be used, as specified in section . If neither sheetName nor rangeName specify a sheet (2), the protocol server MAY<26> use any sheet (2) in the workbook. If sheetName is empty and rangeName specifies a sheet (2), as defined in section , the sheet (2) that is specified by rangeName MUST be used to locate the range. Each element inside the rangeValues element MUST be of type ArrayOfAnyType and be a of worksheet cells. The number of rows in rangeValues MUST be equal to the number of rows specified in the rangeName element. Each element inside each of the ArrayOfAnyType type nested inside rangeValues MUST be a single worksheet cell. The number of elements inside each such nested ArrayOfAnyType MUST be equal to the number of specified in the rangeName element. All worksheet cells in the rangeValues element MUST either be empty and have the xsi:nil attribute set to true or be one of the following types: boolean, dateTime, decimal, double, float, int, short, string, or unsigned byte. If the value is of type string, it MUST NOT be longer than 32767 characters. If the protocol server does not support the it MUST return a . If the protocol server does not support setting a value in the specified location, it MUST return a SOAP fault.
A Abstract data model 41 20 22 22 23 27 27 C 20 25 177 28 28 37 22 22 22 23 23 23 24 D Data - abstract 41 E Events 130 130 Examples 131 131 134 F Faults 37 20 148 G 131 13 27 I 147 147 19 Initialization 41 13 L 28 Local events 130 M Message processing 41 Messages 22 22 23 27 27 25 28 37 22 22 21 28 27 21 23 25 26 26 24 23 21 21 24 27 N 21 17 O Operations 43 45 48 51 53 55 58 60 62 65 68 71 74 77
80 84 86 88 90 94 96 99 101 104 106 109 111 113 116 119 122 125 128 19 19 19 P 147 20 20 175 Protocol Details 40 R 23 25 17 19 17 134 20 Request timeout 41 19 S 26 Security 147 147 Sequencing 41 Server 41 43 45 48 51 53 55 58 60 62 65 68 71 74 77 80 84 86 41 130 41 88 90 94 96 99 101 104 106 109 111 41 113 116 119 122 125 128 130 Session timeout 41 26 24 25 25 26 26 27 20 23 Syntax 21 T Timer events 130 Timers 41 41 177 21 24 Types 22 24 V 20 20 W 27 148