Sets a classic XLS AutoFilter range and applies a per-field criterion in one call

ApplyAutoFilter(ARange: WideString; Field: Integer; Criteria1: Variant; Operator: XlAutoFilterOperator; Criteria2: Variant);

ApplyAutoFilter(ARange: WideString; Field: Integer; Criteria1: Variant);

ApplyAutoFilter(ARange: WideString; Field: Integer; Criteria1: Variant; Operator: XlAutoFilterOperator; Criteria2: Variant); ApplyAutoFilter(ARange: WideString; Field: Integer; Criteria1: Variant; Operator: XlAutoFilterOperator; Criteria2: Variant); ApplyAutoFilter(ARange: WideString; Field: Integer; Criteria1: Variant; Operator: XlAutoFilterOperator; Criteria2: Variant);;

ApplyAutoFilter(ARange: WideString; Field: Integer; Criteria1: Variant; Operator: XlAutoFilterOperator; Criteria2: Variant); ApplyAutoFilter(ARow1, ACol1, ARow2, ACol2: Integer; Field: Integer; Criteria1: Variant; Operator: XlAutoFilterOperator; Criteria2: Variant); ApplyAutoFilter(ARange: WideString; Field: Integer; Criteria1: Variant; Operator: XlAutoFilterOperator; Criteria2: Variant);;

ApplyAutoFilter(ARange: WideString; Field: Integer; Criteria1: Variant; Operator: XlAutoFilterOperator; Criteria2: Variant); ); Workbook.SaveAs( ApplyAutoFilter(ARange: WideString; Field: Integer; Criteria1: Variant; Operator: XlAutoFilterOperator; Criteria2: Variant);;

'A1:C5'

to inspect the stored per-field criteria after applying or reading a classic XLS AutoFilter A1:C5); Workbook.SaveAs(

Workbook := TXLSWorkbook.Create; try Sheet := Workbook.Sheets[ IXLSRange.Autofilter

'A1:C5' TXLSWorksheet.AutoFilterColumns.Find(Field) '>=100'

); Workbook.SaveAs(

Workbook := TXLSWorkbook.Create;
try
  Sheet := Workbook.Sheets[1];
  Sheet.ApplyAutoFilter('A1:C5', 2, '>=100');
  Workbook.SaveAs('filtered.xls', xlExcel97);
finally
  Workbook.Free;
end;

'filtered.xls'

, xlExcel97); finally Workbook.Free; end;
'filtered.xls'
TXLSWorksheet.AutoFilterColumnsypatybė
TXLSWorksheet.AutoFilterRangeypatybė
TXLSWorksheet.ClearAutoFiltermetodas
IXLSRange.Autofiltermetodas