Spread WinForms 15
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

Reference

IExcelXml Interface
IExcelXml Members

 

 

Copyright © 2021 GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page