Spire.XLS API

AutoFiltersCollection MatchNonBlanks Method (FilterColumn)

Match all not blank cell in the list.

Namespace: Spire.Xls.Collections
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

public void MatchNonBlanks(
	FilterColumn column
)

Public Sub MatchNonBlanks ( 
	column As FilterColumn
)

public:
void MatchNonBlanks(
	FilterColumn^ column
)

member MatchNonBlanks : 
column : FilterColumn -> unit

column: Type: Spire.Xls.Core.Spreadsheet.AutoFilter FilterColumn
The column field on which you want to base the filter . for exapmle: sheet.AutoFilters[0]

AutoFiltersCollection AddLanguageSpecificTextSet("LST422FEAE9_0?cpp=::|nu=."); MatchNonBlanks Method (FilterColumn)