2.2.4 Complex Types

The following table summarizes the set of common XML Schema complex type definitions defined by this specification. XML Schema complex type definitions that are specific to a particular operation are described with the operation.

Complex Type

Description

ArrayOfAnyType

The ArrayOfAnyType type is an array of anyType elements.

ArrayOfAutoFilterCriteria

The ArrayOfAutoFilterCriteria type is an array of AutoFilterCriteria elements (section 2.2.4.12).

ArrayOfAutoFilterDateNodeInfo

The ArrayOfAutoFilterDateNodeInfo complex type is an array of AutoFilterDateNodeInfo elements (section 2.2.4.13).

ArrayOfExcelServerMessage

The ArrayOfExcelServerMessage type is an array of ExcelServerMessage elements (section 2.2.4.23).

ArrayOfInt

The ArrayOfInt type is an array of integer elements.

ArrayOfPivotFilterItem

The ArrayOfPivotFilterItem type is an array of PivotFilterItem elements (section 2.2.4.26).

ArrayOfPresenceUserInfo

The ArrayOfPresenceUserInfo type is an array of PresenceUserInfo elements (section 2.2.4.30).

ArrayOfRangeValuesA1

The ArrayOfRangeValuesA1 type is an array of RangeValuesA1 elements (section 2.2.4.31).

ArrayOfSlicerFormatElement

An array of SlicerFormatElement elements (section 2.2.4.37). The position of the SlicerFormatElement in the array indicates which slicer visual component the SlicerFormatElement is applied to.

ArrayOfSlicerItem

An array of SlicerItem elements (section 2.2.4.39).

ArrayOfString

The ArrayOfString complex type is an array of string elements.

AutoFilterCriteria

Used to instruct the protocol server on how to apply a filter on an AutoFilter in the workbook. This complex type is used as part of the AutoFilterOptions complex type (section 2.2.4.14) through the ArrayOfAutoFilterCriteria complex type (section 2.2.4.2).

AutoFilterDateNodeInfo

Specifies how AutoFilter filter date values are filtered by the protocol server.

AutoFilterOptions

Used to specify the filter applied to an AutoFilter column (2).

BorderFormat

Specifies the formatting to apply to the border of the slicer visual components.

CellCompoundValue

The CellCompoundValue complex type contains the number formatted and the unformatted value of a cell.

CollaborationParameter

The CollaborationParameter complex type encapsulates input about end user presence.

CollaborationResult

The CollaborationResult complex type encapsulates output about end user presence.

CollaborationState

The CollaborationState complex type encapsulates information about the state of the end user presence information.

CommandParameter

The CommandParameter complex type is an input used by some protocol server operations.

CommandResult

The CommandResult complex type is an operation response message used by most protocol server operations.

CommandResultExtendedInfo

The CommandResultExtendedInfo complex type provides extended information for CommandResult (section 2.2.4.21).

ExcelServerMessage

An alert information returned by the protocol server.

ExcelServerMessage

An alert information returned by the protocol server.

PeriodicRefreshInfo

The PeriodicRefreshInfo complex type is used to return expired external data related information.

PivotFilterItem

A PivotTable member that is part of a PivotTable manual filter hierarchy.

PivotFilterItemList

A list of PivotTable members.

PivotOperationOptions

The PivotOperationOptions type is a container for common information used in PivotTable operations.

PresenceUserId

The PresenceUserId complex type contains identifying information about end user presence for a single participant in the session (2).

PresenceUserInfo

The PresenceUserInfo complex type contains information about end user presence for a single participant in the session (2).

RangeValuesA1

The RangeValuesA1 type is used to transfer the values of the cells specified by RangeName.

RequestLimits

Specifies a limit on a protocol server operation.

ServerHealthInformation

Used to return information about the health of the protocol server.

ServerHealthInformation

Used to return information about the health of the protocol server.

SheetRange

Specifies a range on a worksheet in a workbook.

SlicerFontType

Font specification for a slicer visual component.

SlicerFormatElement

A slicer formatting specification.

SlicerFormatElementList

 Contains an ArrayOfSlicerFormatElement element (section 2.2.4.9).

SlicerItem

Specifies the visual representation for a slicer item.

SlicerItemList

 Contains an ArrayOfSlicerItem element (section 2.2.4.10).

SlicerOptions

A container for common information related to a slicer.

SlicerView

Specifies slicer attributes such as display properties specific to the slicer and attributes describing the slicer items.

TypeExporter

MUST NOT be used.

VisibleSheetRange

The VisibleSheetRange complex type is used to specify the Workbook, as specified in [MS-EXSPXML] section 2.1.1, to be returned in the response message.

WorkOnBehalf

MUST NOT be used.