By allentatakai
Prepare the input
Choose a rectangle that includes the intended headers and all relevant records. Check for blank separator rows that might indicate separate data blocks.
These examples use local sample filenames. Substitute your own paths and check jetformat excel filter --help against the installed version before running the task. Put paths containing spaces inside quotes.
Run the command
jetformat excel filter finance.xlsx --sheet Summary --range A1:C20 -o finance-updated.xlsx
An AutoFilter marks a range for filtering in a spreadsheet viewer. Adding it does not express a business filter condition or guarantee that rows have been removed.
Review before the next step
Open the saved workbook and inspect the filter controls. Defining a filter range is not the same as selecting criteria or deleting rows that do not match.
Open the output and check the filter range and header row; compare row counts before treating it as filtered data.
Keep the workflow repeatable
Writing an Office document uses one credit per command. See the billing guide for the current rules.
Keep the input revision with the result so a later reviewer can reproduce the decision. For a write operation, choose a new output path first; use overwrite flags only when replacing a previously reviewed result is intentional.
See the excel filter options and examples for the command reference. Browse related excel commands when the next step requires a different operation.