SetAutoFilter Method

In This Topic

Add an IExcelAutoFilter instance to the specified sheet

Syntax

'Declaration
 
Sub SetAutoFilter( _
   ByVal sheet As Short, _
   ByVal autoFilter As IExcelAutoFilter _
)

'Usage
 
Dim instance As IExcelReader
Dim sheet As Short
Dim autoFilter As IExcelAutoFilter
 
instance.SetAutoFilter(sheet, autoFilter)

void SetAutoFilter( 
   short sheet,
   IExcelAutoFilter autoFilter
)

sheet: The zero based sheet index used to locate the IExcelWorksheet instance
autoFilter: An IExcelAutoFilter instance used to represents an active AutoFilter