3.1.4.32 SetRange

  • Article

This operation is used to set values to a range of worksheet cells on a workbook.

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

 <wsdl:operation name="SetRange" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
   <wsdl:input message="tns:SetRangeSoapIn"/>
   <wsdl:output message="tns:SetRangeSoapOut"/>
 </wsdl:operation>

  1. The rangeCoordinates on the sheet (2) specified by sheetName; specify the location of the worksheet cells to set.

  2. If the user does not have the Open Item permission on the workbook, rangeValues SHOULD<25> contain only one item.

  3. Each element inside the rangeValues element MUST be of type ArrayOfAnyType and be a row of worksheet cells. The number of rows in rangeValues MUST be equal to the number of rows specified in the rangeCoordinates element.

  4. 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 columns specified in the rangeCoordinates element.

  5. All worksheet cells in the rangeValues element MUST either be empty and have the xsi:nil attribute set to true or one be of the following types: boolean, dateTime, decimal, double, float, int, short, string, or unsigned byte.

    1. If the value is of type string, it MUST NOT be longer than 32,767 characters.

    2. If the protocol server does not support the value, it MUST return a SOAP fault.

    3. If the protocol server does not support setting a value in the specified location, it MUST return a SOAP fault.

  6. If there was an application error on the protocol server during the operation, the protocol server MUST return a SOAP fault response, which SHOULD contain one of the following subcodes or any other subcodes specified in section 2.2.9.2, but MAY instead contain any subcode specified in section 2.2.9.1 or any other subcode.

    Subcode

    FormulaParseFailed

    InvalidSheetName

    DimensionAndArrayMismatch

    SheetRangeMismatch

    RangeParseError