3.1.4.75 DdaSetSelectedData

  • Article

Sets worksheet cell contents associated with the given range.

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

 <wsdl:operation name="DdaSetSelectedData" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
   <wsdl:input wsaw:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/DdaSetSelectedData" message="tns:ExcelServiceSoap_DdaSetSelectedData_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/DdaSetSelectedDataResponse" message="tns:ExcelServiceSoap_DdaSetSelectedData_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/DdaSetSelectedDataExcelServerMessageFault" name="ExcelServerMessageFault" message="tns:ExcelServiceSoap_DdaSetSelectedData_ExcelServerMessageFault_FaultMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
 </wsdl:operation>

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

  1. The protocol client sends information identifying the Office Web Extension, a matrix of cell contents, and a range string that describes the selected range.

  2. The protocol server parses the string to a range on a worksheet and sets the cell contents in that range.

  3. Each element inside the data element MUST be of type ArrayOfAnyType and be a row of worksheet cell data sent to the protocol server. The number of rows in data MUST be equal to the number of rows in the specified binding element minus the value of the row index of the first cell in the selected data.

  4. Each element inside each of the ArrayOfAnyType type nested inside data MUST be a single worksheet cell. The number of elements inside each such nested ArrayOfAnyType MUST be equal to the number of columns in the specified binding minus the value of the column index of the first cell in the selected data.

  5. All worksheet cells in the data element MUST either be empty and with the xsi:nil attribute set to true or 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 value, it MUST fail. If the protocol server does not support setting a value in the specified location, it MUST fail.

  6. If the given cell matrix does not exactly match the selected range then this method MUST fail.

This operation is 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<91> be one of the values specified in section 2.2.2.1 or any of the following values:

  • DdaUnsupportedCoercionType

  • DdaWriteSelectionShapeAndDataMismatch

  • DdaWriteDataOverlap

  • DdaWriteDataOverflow

  • DdaWriteInvalidRowColOffset

  • DdaWriteCoercionDataMismatch

  • DdaWriteCoercionSelectionMismatch