ExcelGetAutoFilter Method
Gets the Excel XML auto filter.
'Declaration
Function ExcelGetAutoFilter( _
ByVal As Short, _
ByRef startColumn As Integer, _
ByRef endColumn As Integer, _
ByRef As Integer, _
ByRef As Integer, _
ByRef As ArrayList, _
ByRef 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)
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