IXlsAutoFilter

COM interface ( getting help with interfaces )

interface IXlsAutoFilter : IDispatch
{
  [id(1), propget] HRESULT CustomFilter([in]int columnIndex, [out,retval]IXlsCustomFilter** customFilter);
  [id(2)         ] HRESULT Apply();

}

HRESULT CustomFilter([in]int columnIndex, [out,retval]IXlsCustomFilter** customFilter);
returns the custom filter for the passed column index. The column index is 1-based.

HRESULT Apply();
applies all filters of the auto-filter. Whenever a custom filter is added, it is automatically applied.