Microsoft Excel

Filter Worksheet

Activity filters an Excel worksheet.

Fill in Filter By Column to choose a column and Filtered Values to provide a list of values to display.

filterworksheet1
filterworksheet2
NameTypeCategoryDescription
Filter By ColumnInt32InputExcel column to filter
Filtered ValuesString[]Inputvalues to filter by
Workbook NameStringInputcustom internal name Wizlink will use to identify the workbook
Worksheet NameStringInputname of the Excel sheet
Retry Timeout [s]DoubleInputdetermines behaviour if the activity fails to execute. value < 0: try executing once, 0: try indefinitely; value >0: time in seconds during which the activity repeatedly tries to execute (if time elapses without success then Result = False, end activity)
Alternative Scenario If FailedBooleanMisccheckbox; default is "on"
Display NameLiteralMiscchanges display name of the activity
Exclude from Transaction CheckBooleanMisccheckbox; default is "off"
ResultBooleanOutputreturns a Boolean value. True if no error in activity, otherwise will return False
Result CodeInt32OutputResult Code will return 0 if there is no error in activity, otherwise in most cases will return 1. See the table of Extended Result Codes for more info