3.1.4.33 SetRangeA1

  • 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 SetRangeA1 WSDL operation.

 <wsdl:operation name="SetRangeA1" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
   <wsdl:input message="tns:SetRangeA1SoapIn"/>
   <wsdl:output message="tns:SetRangeA1SoapOut"/>
 </wsdl:operation>

  1. The sheet (2) 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 2.2.5.4.

    • If neither sheetName nor rangeName specify a sheet (2), the protocol server MAY<26> use any sheet (2) in the workbook.

  2. If sheetName is empty and rangeName specifies a sheet (2), as defined in section 2.2.5.2, the sheet (2) that is specified by rangeName MUST be used to locate the range.

  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 rangeName 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 rangeName element.

  5. 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 value, it MUST return a SOAP fault.

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

  6. If the user does not have the Open Item permission on the workbook, rangeValues SHOULD<27> contain only one worksheet cell.