WorksheetAdvancedFilter Method
Filters data using complex criteria.

Namespace: Aspose.Cells
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: 19.11.0.0 (19.11)
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