ExcelSetAutoFilter Method

In This Topic

Sets the Excel XML auto filter.

Syntax

Visual Basic
C#

'Declaration
 
Function ExcelSetAutoFilter( _
   ByVal sheet As Short, _
   ByVal startColumn As Integer, _
   ByVal endColumn As Integer, _
   ByVal startRow As Integer, _
   ByVal endRow As Integer, _
   ByVal filterString As ArrayList _
) As Boolean

'Usage
 
Dim instance As IExcelXml
Dim sheet As Short
Dim startColumn As Integer
Dim endColumn As Integer
Dim startRow As Integer
Dim endRow As Integer
Dim filterString As ArrayList
Dim value As Boolean
 
value = instance.ExcelSetAutoFilter(sheet, startColumn, endColumn, startRow, endRow, filterString)

bool ExcelSetAutoFilter( 
   short sheet,
   int startColumn,
   int endColumn,
   int startRow,
   int endRow,
   ArrayList filterString
)

Parameters

sheet: Sheet index
startColumn: Starting column index
endColumn: Ending column index
startRow: Starting row index
endRow: Ending row index
filterString: Filter string

Reference

IExcelXml Interface
IExcelXml Members

Product Support Forum | Print this page