2.2.5.3 AutoFilterOperationType

Namespace: http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/

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).

 <xs:simpleType name="AutoFilterOperationType" xmlns:xs="http://www.w3.org/2001/XMLSchema">
   <xs:restriction base="xs:string">
     <xs:enumeration value="EQ"/>
     <xs:enumeration value="NEQ"/>
     <xs:enumeration value="GT"/>
     <xs:enumeration value="GTEQ"/>
     <xs:enumeration value="LT"/>
     <xs:enumeration value="LTEQ"/>
     <xs:enumeration value="LastCount"/>
   </xs:restriction>
 </xs:simpleType>

The following table specifies the allowable values for the AutoFilterOperationType simple type.

Value

Meaning

EQ

Filter all data that is equal to the value.

NEQ

Filter all data that is not equal to the value.

GT

Filter all data that is greater than the value.

GTEQ

Filter all data that is either greater than or equal to the value.

LT

Filter all data that is less than the value.

LTEQ

Filter all data that is less than or equal to the value.

LastCount

MUST NOT be used.