SetAutoFilter(ARange: WideString);
SetAutoFilter(ARow1, ACol1, ARow2, ACol2: Integer);
SetAutoFilter(ARange: WideString); SetAutoFilter(ARange: WideString); SetAutoFilter(ARange: WideString);;
SetAutoFilter(ARange: WideString); The numeric SetAutoFilter(ARange: WideString); uses 1-based row and column indexes. The string SetAutoFilter(ARange: WideString); accepts an A1-style range such as SetAutoFilter(ARange: WideString);;
To set a field condition while creating the range, call
]; Sheet.SetAutoFilter( A1:C5'A1:C5'
); Workbook.SaveAs( TXLSWorksheet.ApplyAutoFilter]; Sheet.SetAutoFilter( IXLSRange.Autofilter(Field, Criteria) 'A1:C5'
); Workbook.SaveAs(
Workbook := TXLSWorkbook.Create;
try
Sheet := Workbook.Sheets[1];
Sheet.SetAutoFilter('A1:C5');
Workbook.SaveAs('filtered.xls', xlExcel97);
finally
Workbook.Free;
end;
'filtered.xls'