3.1.4 Message Processing Events and Sequencing Rules
This protocol includes the operations described in the following table.
|
Operation |
Description |
|---|---|
|
This operation is used to change the filtering of a table or worksheet AutoFilter in the workbook. |
|
|
ApplyPivotFilter |
This operation is used to apply a PivotTable custom filter or a PivotTable manual filter on a PivotTable field. |
|
ApplyPivotSort |
This operation is used to change the sort order (2) of a PivotTable field in the workbook. |
|
ApplyPivotTop10Filter |
This operation is used to apply a top N filter or a bottom N filter on a PivotTable field. |
|
ApplyTop10Filter |
This operation is used to apply a top N filter or a bottom N filter on a column (2) in a worksheet or in a table. |
|
CancelRequest |
This operation is used to cancel an operation that is currently running on the protocol server. |
|
CloseWorkbook |
This operation is used to close a session (2) on the protocol server. |
|
ConnectAndGetPivotFilterItemList |
This operation is used to return the PivotTable members that are part of a PivotTable manual filter hierarchy. |
|
ExpandCollapseOutline |
This operation is used to toggle the outline state in the workbook. |
|
FindRange |
This operation is used to find a string inside a workbook. What constitutes a match between the search string and the contents of the workbook is dependent on the protocol server implementation. |
|
GetAutoFilterItemList |
This operation is used to retrieve the filter values and filter date values and their caption in the AutoFilterItemList in the operation response for an AutoFilter in the workbook. |
|
GetImage |
This operation is used to return a chart image. |
|
GetPivotFilterItemList |
This operation is used to return child PivotTable members that are part of a PivotTable manual filter hierarchy. This operation is used after calling ConnectAndGetPivotFilterItemList or after calling GetPivotFilterItemList for an ancestor in the hierarchy. |
|
GetPivotMenu |
This operation is used to return information about a PivotTable area. |
|
GetRange |
This operation is used to get an SpreadsheetDataXML range. |
|
GetRangeValues |
This operation is used to get the values contained in a specified range in a workbook. |
|
GetRangeValuesA1 |
This operation is used to get the values contained in a specified range in a workbook. |
|
GetSessionInformation |
This operation is used to return information about a session (2). |
|
GetWorkbook |
This operation is used to retrieve a workbook file. |
|
OpenWorkbook |
This operation is used to open a session (2) giving access to a workbook on the protocol server. |
|
Recalc |
This operation is used to calculate a specified range in the workbook. |
|
RecalcA1 |
This operation is used to calculate a specified range in the workbook. |
|
RecalcAll |
This operation is used to calculate the workbook. |
|
Refresh |
This operation is used to refresh connected data on a workbook. |
|
RefreshAll |
This operation is used to refresh all connected data on a workbook. |
|
RemovePivotFilter |
This operation is used to remove any PivotTable filters that are applied to a PivotTable field. |
|
SetParameters |
This operation is used to set values of workbook parameters in a workbook. |
|
SetRange |
This operation is used to set values to a range of worksheet cells on a workbook. |
|
SetRangeA1 |
This operation is used to set values to a range of worksheet cells on a workbook. |
|
SortFilterColumn |
This operation is used to change the sort order (2) of a table or worksheet AutoFilter in the workbook. |
|
TogglePivotDrill |
This operation is used to expand or collapse a PivotTable member. |