3.1.4.14 GetPivotMenu

This operation is used to return information about a PivotTable area.

 <wsdl:operation name="GetPivotMenu">
     <wsdl:input message="GetPivotMenuSoapIn" />
     <wsdl:output message="GetPivotMenuSoapOut" />
 </wsdl:operation>

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

  1. The protocol client sends the information identifying the PivotTable area in the pivotFilterOptions element.

  2. The protocol server returns the PivotTable area information in the pivotMenu element.

In the event of an application error on the protocol server during this operation, the protocol server MUST return an ExcelServerMessage as specified in section 2.2.9.2. The id element of the ExcelServerMessage MUST be one of the values specified in section 2.2.9.4, and SHOULD<22> be one of the following values.

Id

Description

InvalidOrTimedOutSession

See section 2.2.9.5.

RetryError

See section 2.2.9.5.

OperationCanceled

See section 2.2.9.5.

InternalError

See section 2.2.9.5.

MultipleRequestsOnSession

See section 2.2.9.5.

MaxRequestDurationExceeded

See section 2.2.9.5.