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.


Name | Type | Category | Description |
---|---|---|---|
Filter By Column | Int32 | Input | Excel column to filter |
Filtered Values | String[] | Input | values to filter by |
Workbook Name | String | Input | custom internal name Wizlink will use to identify the workbook |
Worksheet Name | String | Input | name of the Excel sheet |
Retry Timeout [s] | Double | Input | determines 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 Failed | Boolean | Misc | checkbox; default is "on" |
Display Name | Literal | Misc | changes display name of the activity |
Exclude from Transaction Check | Boolean | Misc | checkbox; default is "off" |
Result | Boolean | Output | returns a Boolean value. True if no error in activity, otherwise will return False |
Result Code | Int32 | Output | Result 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 |