'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 IExcelReadOptimized 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