Filter Sheet
Filter rows (first row = headers) by a column condition into a DataTable.
Overview
Filter Sheet is a no-code automation step in the Excel category of AutoFlowRPA. It performs its action in a single step when the workflow reaches it. You can configure 6 parameter(s) to control exactly how it behaves. It is one of 369 commands you can drag into a workflow in the visual builder — no scripting required.
What it does
Filter rows (first row = headers) by a column condition into a DataTable.
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
| Excel instance | variable | Required | excel | Name that identifies this open workbook. |
| Sheet (blank = active) | string | Optional | Worksheet name; blank uses the active sheet. Supports variables | |
| Column header | string | Required | Supports variables | |
| Condition | dropdownis equal to · is not equal to · is greater than · is less than · is greater than or equal to · is less than or equal to · contains · does not contain · is empty · is not empty | Required | is equal to | |
| Value | string | Optional | Supports variables | |
| Store DataTable in | variable | Required | Example: filtered |
How to use Filter Sheet
- 1
Open AutoFlowRPA and drag the Filter Sheet command from the Excel group onto the canvas.
- 2
Set its parameters in the side panel — Filter Sheet has 6 configurable field(s).
- 3
Connect it into your workflow and press Run. Everything executes locally on your machine.
Frequently asked questions
What does the Filter Sheet command do?
Filter rows (first row = headers) by a column condition into a DataTable.
Which group does the Filter Sheet command belong to?
Filter Sheet is part of the Excel group. AutoFlowRPA ships with 369+ ready-made commands you can combine without code.
Does the Filter Sheet command take any parameters?
Yes — Filter Sheet has 6 configurable field(s), all editable in the visual node editor.
More Excel commands
Ready to automate your busywork?
Start your free 30-day trial today. No credit card, no commitment.