ExcelGetAutoFilter Method

In This Topic

Gets the Excel XML auto filter.

Syntax

Visual Basic
C#

'Declaration
 
Function ExcelGetAutoFilter( _
   ByVal sheet As Short, _
   ByRef startColumn As Integer, _
   ByRef endColumn As Integer, _
   ByRef startRow As Integer, _
   ByRef endRow As Integer, _
   ByRef filterStringList As ArrayList, _
   ByRef filterOutRows As Hashtable _
) 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 filterStringList As ArrayList
Dim filterOutRows As Hashtable
Dim value As Boolean
 
value = instance.ExcelGetAutoFilter(sheet, startColumn, endColumn, startRow, endRow, filterStringList, filterOutRows)

bool ExcelGetAutoFilter( 
   short sheet,
   ref int startColumn,
   ref int endColumn,
   ref int startRow,
   ref int endRow,
   ref ArrayList filterStringList,
   ref Hashtable filterOutRows
)

Parameters

sheet: Sheet index
startColumn: Starting column index
endColumn: Ending column index
startRow: Starting row index
endRow: Ending row index
filterStringList: Filter string
filterOutRows: Filtered-out rows

Reference

IExcelXml Interface
IExcelXml Members

Product Support Forum | Print this page