Spread Windows Forms 15.0
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelXml Interface / ExcelSetAutoFilter Method
Sheet index
Starting column index
Ending column index
Starting row index
Ending row index
Filter string


In This Topic
    ExcelSetAutoFilter Method
    In This Topic
    Sets the Excel XML auto filter.
    Syntax
    '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)

    Parameters

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