By Jetformat
Choose the sheet, sort column, and direction explicitly. Check the dataset and header before sorting so the result still associates each record with the correct values.
Steps
- Start with a local XLSX. Replace the sample paths and identifiers with your own.
- Run the command below. Save to a new output path so the source remains available for comparison.
- Check the result as described below before using it in another job.
jetformat excel sort finance.xlsx --sheet Summary --column A --order asc -o finance-updated.xlsxOptions for this task
| Option | Meaning |
|---|---|
--column |
Sort column, for example C |
--header-row |
1-based header row; that row is not sorted (default 1) |
--order |
asc or desc (default “asc”) |
--output |
Output XLSX path (required) |
--sheet |
Worksheet name (required) |
Check the result
Read several rows before and after sorting and verify both order and row relationships.
Notes and limits
Writing an Office document uses one credit per command. See the billing guide for the current rules.
The examples keep the original file. Add --force only when you intend to overwrite an existing output. Run jetformat excel sort --help to compare options with your installed version.
See the excel command reference for the surrounding workflow.