2.2.5 Simple Types

  • Article

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

Simple type

Description

AutoFilterCriteriaType

Specifies how data is to be filtered by the protocol server when using the AutoFilterOptions complex type (section 2.2.4.14).

AutoFilterDateNodeType

Specifies how AutoFilter dates data is filtered by the protocol server when using the AutoFilterDateNodeInfo (section 2.2.4.13).

AutoFilterOperationType

Used to instruct the protocol server which comparison method to use when filtering worksheets or tables. All data that is being filtered is compared to the Value element in the AutoFilterCriteria complex type (section 2.2.4.12).

AutoFilterRelationOperator

Specifies the relationship between an AutoFilterCriteria element (section 2.2.4.12) contained in an ArrayOfAutoFilterCriteria (section 2.2.4.2) and the one that potentially follows it.

CommandParameterFlags

Specifies various options to modify the behavior of operations.

DdaBindingType

Type of Office Web Extension binding.

DdaCoerceType

Describes the data format of a result from a Document Data Access method.

DdaFilterType

Specifies which type of cells the Document Data Access is applied to.

DdaValueType

The type of cell data used in the operation.

ExcelServerFeature

Represents a collection of features that is implemented by the protocol server or client.

ExcelServerMessageAppearance

Specifies the control buttons associated with an alert that the protocol server returns to the protocol client. The list MUST contain either only the value OK or the both the values Yes and No.

ExcelServerMessageAppearance

Specifies a list of enumeration values corresponding to either control buttons or a Message Bar notification, which is associated with an alert that the protocol server returns to the protocol client. The list MUST contain one of the following:

  • OK

  • Notification

  • Both Yes and No

  • Both Notification and OK

ExcelServerMessageId

The ExcelServerMessageId type is an enumeration of alerts returned from the protocol server.

ExcelServerMessageId

The ExcelServerMessageId type is an enumeration of values, each of which corresponds to a particular alert that is passed between the protocol client and the protocol server.

ExcelServerMessageSeverity

Specifies the severity of the alert that the protocol server returns to the protocol client.

ExcelServerMessageSeverity

Specifies the severity of the alert that the protocol server returns to the protocol client.

ExcelServerMessageType

Specifies type of the alert that the protocol server returns to the protocol client.

ExcelServerMessageType

Specifies the type of the alert that the protocol server returns to the protocol client.

GridRenderingOptions

Specifies options to use when rendering a Workbook ([MS-EXSPXML3] section 2.1.1).

guid

Specifies a GUID value, as specified in [RFC4122].

ImageRenderingOptions

Specifies the options to use when rendering an image or chart.

NamedObjectType

Specifies the type of a published item.

OpenWorkbookFlags

Control flags for OpenWorkbook.

PivotFilterType

The PivotFilterType is an enumeration of types of PivotTable filters that can be applied on a PivotTable field. The following types of PivotTable filters are supported:

RangeReference

A string that is used by the protocol server to identify a range on a worksheet in a workbook, in operations specified by this protocol. MUST NOT be longer than 32,768 characters. MAY<8> use any format to identify the range.

ResourceThrottlingScenario

MUST NOT be used.

RestSlicerSelectionMode

Indicates the behavior to follow when updating the state of the slicer selection.

RestTimelineLevel

Indicates the granularity of the time period in a timeline.

RestTimelineSelectionState

Indicates the selection mode for filtering a timeline.

ScenarioRestrictions

Indicates the scenarios which apply to the current request.

ServerStateFlags

Specifies the state of the protocol server.

ServerStateFlags

An enumeration specifying the state of the protocol server.

SessionIdentifier

The SessionIdentifier string is used to uniquely identify a session (2) on the protocol server, and to contain information about the session (2).

The SessionIdentifier MUST have the following layout. (Numeric values in parts 1, 3, 5, 6, 8, 10, and 12 MUST follow the s:integer type representation.)

  • Part 1: MUST be the value 1, followed by a period (.).

  • Part 2: MUST be "E" if the identified session (2) is an edit session. MUST be "G" if the identified session (2) is a new workbook session created by GenerateWorkbookFromHtml (section 3.1.4.50). Otherwise, MUST be "V".

  • Part 3: The number of characters in part 4, followed by a period (.).

  • Part 4: A unique string. MUST be greater than or equal to 20 and less than or equal to 32,647 characters long.

  • Part 5: The sum of number of characters in parts 6-9, followed by a period (.).

  • Part 6: The number of characters in part 7, followed by a period (.).

  • Part 7: The UI culture of the session (2). A language tag, as specified in [RFC1766], Section 2.

  • Part 8: The number of characters in part 9, followed by a period (.).

  • Part 9: The data culture of the session (2). A language tag, as specified in [RFC1766], Section 2.

  • Part 10: The number of characters in part 11, followed by a period (.).

  • Part 11: MUST be equal to the value of RequestSiteId passed in parameter, in the OpenWorkbook operation.

  • Part 12: The number of characters in part 13, followed by a period (.).

  • Part 13: If the identified session (2) is a new workbook session created by GenerateWorkbookFromHtml, MUST be the trusted location of the new workbook session. Else if the identified session (2) is any other new workbook session, then MUST be "U".

Otherwise, if the identified session (2) is not an edit session, MUST be "N". If the identified session (2) is an edit session, MUST be a unique string. The protocol server uses this string to uniquely identify a participant in the session.

SharedPivotMenuAnchorType

Type information about a PivotTable or PivotTable anchor.

SheetFlags

Describes options for a sheet (1).

SheetType

Indicates the type of a sheet (1).

SheetVisibility

Indicates the visibility state of a sheet (2).

SlicerOptionsBits

Specifies options for operations on slicers.

SortByType

Indicates the type of a sort operation.

StateSortBy

Indicates the state of a sort operation.

Top10FilterType

The Top10FilterType type is an enumeration that specifies the type of top N filter or bottom N filter that is applied to a PivotTable field.

UndoRedoEnabledState

Indicates the current enabled state of undo and redo operations.

WorkbookType

The WorkbookType simple type is an enumeration that is used to specify the form of the requested workbook.