Syncfusion.XlsIO.Base


Whether filter in the place or copy to another place.
The filter range.
The criteria range.
The destination range for the copied rows if ExcelFilterAction is FilterCopy. Otherwise, this argument is ignored.
True to filter unique records; Otherwise filters all the records that meet the criteria. The default value is False.

AdvancedFilter Method

Filters or copies data from a list based on a criteria range..
Syntax
'Declaration
 
Sub AdvancedFilter( _
   ByVal filterInPlace As ExcelFilterAction, _
   ByVal filterRange As IRange, _
   ByVal criteriaRange As IRange, _
   ByVal copyToRange As IRange, _
   ByVal isUnique As Boolean _
) 
'Usage
 
Dim instance As IWorksheet
Dim filterInPlace As ExcelFilterAction
Dim filterRange As IRange
Dim criteriaRange As IRange
Dim copyToRange As IRange
Dim isUnique As Boolean
 
instance.AdvancedFilter(filterInPlace, filterRange, criteriaRange, copyToRange, isUnique)

Parameters

filterInPlace
Whether filter in the place or copy to another place.
filterRange
The filter range.
criteriaRange
The criteria range.
copyToRange
The destination range for the copied rows if ExcelFilterAction is FilterCopy. Otherwise, this argument is ignored.
isUnique
True to filter unique records; Otherwise filters all the records that meet the criteria. The default value is False.
AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.40

See Also