Blocks & Flow EditorExcel

excel filter

The **excel filter** block filters rows based on column conditions.

The excel filter block filters rows based on column conditions.

Bot Studio excel filter block configuration

Configuration

FieldDescription
Display NameOptional label shown on the block in the canvas.
Source File PathFull path to the Excel workbook file (.xlsx). Supports dynamic {variable} substitution from msg.
Source Sheet NameExact name of the worksheet tab (case-sensitive).
Filter TypeSheet — filter entire sheet. Range — filter a cell range.
Cell RangeRange to filter when Filter Type is Range.
Copy Sheet FormatPreserve formatting when filtering.
With HeaderTreat first row as column headers.
Filter ColumnColumn number or header name.
ConditionEquals, Contains, Begins with, Ends with, Greater than, Less than, etc.
Filter ValueValue to filter on.
Case SensitiveWhen checked, match exact case.
Save As New SheetWrite filtered results to a new sheet.
New Sheet NameName for the filtered output sheet.

Outputs

PortDescription
Output 1Message passes through after the operation completes
On this page

On this page