BIMX Table FilterInstall

Summary

Filter rows from an input Excel (XLSX) file by applying one or multiple rules with logical AND or OR, optionally limiting columns and selecting the worksheet, then output a filtered XLSX file.

Inputs

• Binary Property (required) — Name of the binary property containing the input XLSX file (e.g., "xlsx", "file", "data").
• Sheet — Name or index of the worksheet to filter; leave empty to use the first sheet.
• Rules (required) — One or more filter rules, each specifying a field (column), an operator (equals, not equals, contains, regex, etc.), and a value to compare against.
• Logic (required) — Logical operator (AND or OR) to combine multiple filter rules.
• Output Columns — Comma-separated list of columns to include in the output; leave empty to include all columns.
• Chunk Size — Number of rows to process per block for performance and RAM optimization (default 5000).

Output shape

a single binary output containing the filtered XLSX file, accompanied by a JSON object reporting the number of matched rows and output headers

The output binary uses the same property name as the input; the JSON output includes 'matches' (number of filtered rows) and 'headers' (columns in output). If the specified sheet is not found, an error occurs.