By Jetformat
The row number is 1-based and refers to the existing row that should move down. Save a new file when dependent formulas make the change difficult to undo.
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 insert-row finance.xlsx --sheet Summary --row 2 -o finance-updated.xlsxOptions for this task
| Option | Meaning |
|---|---|
--output |
Output XLSX path (required) |
--row |
1-based row number to insert before |
--sheet |
Worksheet name (required) |
Check the result
Read cells above and below the insertion and check formulas that refer to the affected region.
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 insert-row --help to compare options with your installed version.
See the excel command reference for the surrounding workflow.