3.1.4.33 RecalcA1

  • Article

This operation is used to calculate a specified range in the workbook.

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

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

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

  1. If rangeName is empty, the protocol server calculates the whole sheet (2), which is specified in the sheetName element.

  2. If rangeName is not empty, the protocol server calculates the specified range.

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

  • EcsInvalidNamedObject

  • InvalidSheetName

  • RangeDefinitionError

  • RangeParseError

  • SheetRangeMismatch