3.1.4.79 DdaAddRowsColumns

  • Article

Adds the given set of data as rows or columns to a table binding.

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

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

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

  1. The protocol client sends information identifying the Office Web Extension, a binding name, a Boolean value whether to add rows or columns, and a matrix of cell contents.

  2. The protocol server appends a number of rows or columns to the table based on the provided input data, then sets the cell contents within the new rows or columns.

  3. Each element inside the data element MUST be of type ArrayOfAnyType and be a row of worksheet cells sent to the protocol server.

  4. Each element inside each of the ArrayOfAnyType type nested inside data MUST be a single worksheet cell.

  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.

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

  • DdaBindingNotFound

  • DdaBindingUnknownType

  • DdaBindingInvalidRef

  • DdaWriteSelectionShapeAndDataMismatch

  • DdaWriteDataOverlap

  • DdaWriteTableHasNoHeaders