WorksheetAdvancedFilter Method

Filters data using complex criteria.

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 20.3.0.0 (20.3)
Syntax
public void AdvancedFilter(
	bool isFilter,
	string listRange,
	string criteriaRange,
	string copyTo,
	bool uniqueRecordOnly
)

Parameters

isFilter
Type: SystemBoolean
Inidicates whether filtering the list in place.
listRange
Type: SystemString
The list range.
criteriaRange
Type: SystemString
The criteria range.
copyTo
Type: SystemString
The range where copying data to.
uniqueRecordOnly
Type: SystemBoolean
Only displaying or copying unique rows.
See Also