Share via

3.1.4.30 SetCellA1

  • Article

This operation is used to set a value to a specific worksheet cell in the workbook.

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

 <wsdl:operation name="SetCellA1" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
   <wsdl:input message="tns:SetCellA1SoapIn"/>
   <wsdl:output message="tns:SetCellA1SoapOut"/>
 </wsdl:operation>

The protocol client sends a SetCellA1SoapIn request message, and the protocol server responds with a SetCellA1SoapOut response message, as follows:

  1. The sheet (2) that contains the worksheet cell 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<24> 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 protocol server MUST use the sheet (2) that is specified by rangeName to locate the range.

  3. cellValue 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.

    1. If the value is of type string, it MUST NOT be longer than 32767 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.

  4. 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