2.2.4.12 AutoFilterCriteria

  • Article

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

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

 <xs:complexType name="AutoFilterCriteria">
   <xs:sequence>
     <xs:element minOccurs="1" maxOccurs="1" name="Type" type="tns:AutoFilterOperationType"/>
     <xs:element minOccurs="1" maxOccurs="1" name="Relation" type="tns:AutoFilterRelationOperator"/>
     <xs:element minOccurs="0" maxOccurs="1" name="Value" type="xs:string"/>
   </xs:sequence>
 </xs:complexType>

Type: The type of operation as specified in section 2.2.5.3. Used when comparing the Value element as specified in section 2.2.4.14.

Relation: Specifies how to combine an instance of this filter with one appearing after it in an ArrayOfAutoFilterCriteria. When this complex type is the last element inside an ArrayOfAutoFilterCriteria, it MUST contain the "Nil" value specified in section 2.2.5.4. When this complex type is not the last element inside an ArrayOfAutoFilterCriteria, it MUST contain either the "And" or "Or" values specified in section 2.2.5.4.

Value: The string that will be used to filter a worksheet or a table. MUST be present. MUST NOT be longer than 32,768 characters.