3.1.4.69 DdaGetBindingData

  • Article

Returns worksheet cell contents associated with a binding and Office Web Extension.

The following is the WSDL port type specification of the DdaGetBindingData WSDL operation.

 <wsdl:operation name="DdaGetBindingData" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
   <wsdl:input wsaw:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/DdaGetBindingData" message="tns:ExcelServiceSoap_DdaGetBindingData_InputMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
   <wsdl:output wsaw:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/DdaGetBindingDataResponse" message="tns:ExcelServiceSoap_DdaGetBindingData_OutputMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
   <wsdl:fault wsaw:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/DdaGetBindingDataExcelServerMessageFault" name="ExcelServerMessageFault" message="tns:ExcelServiceSoap_DdaGetBindingData_ExcelServerMessageFault_FaultMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
 </wsdl:operation>

The protocol client sends an ExcelServiceSoap_DdaGetBindingData_InputMessage request message, and the protocol server responds with an ExcelServiceSoap_DdaGetindingData_OutputMessage response message, as follows:

  1. The protocol client sends information identifying the Office Web Extension, a binding name, and an optional sub-range.

  2. The protocol server returns cell contents for the binding within the given sub-range. The sub-range MUST be fully contained within the binding range. Each element inside the bindingData element MUST be of type ArrayOfAnyType and is a row of cell contents returned from the protocol server. The number of rows MUST be less than or equal to the number of rows requested.

  3. The result can be filtered to omit values from hidden cells depending on filterType in the request. If filterType is DdaFilterType.OnlyVisible and the requested range contains hidden cells then those rows and columns MUST NOT be in the result.

  4. The result MUST contain either all formatted values or unformatted cell values depending on valueFormat in the request. If valueFormat is DdaValueType.Formatted then all values returned in bindingData MUST be of type string. If valueFormat is DdaValueType.Unformatted then values returned in bindingData MUST be one of the following types: boolean, double, string or CellError (section 3.1.4.34.4.2).

This operation is not a state changing operation on the protocol server.

In the event of an application error on the protocol server during this operation, a SOAP fault is returned, as specified in section 2.2.2. The Id element of the ExcelServerMessage SHOULD<85> be one of the values specified in section 2.2.2.1 or any of the following values:

  • DdaUnsupportedCoercionType

  • DdaReadCoercionBindingMismatch

  • DdaReadInvalidRowColCount

  • DdaReadInvalidRowColOffset

  • DdaReadBeyondDataLimits

  • DdaBindingUnknownType

  • DdaBindingInvalidRef