By Jetformat
Repeat --set and --set-formula to update multiple cells in one invocation. Quote formulas containing shell metacharacters, including multiplication and parentheses.
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 set finance.xlsx --sheet Summary --set A1=5 --set B2=Paid --set-formula 'C1=A1*2' -o finance-updated.xlsxOptions for this task
| Option | Meaning |
|---|---|
--cell |
Cell reference such as A1 |
--formula |
Formula to write into --cell, for example A1+1 |
--output |
Output XLSX path (required) |
--set |
CELL=VALUE, repeatable |
--set-formula |
CELL=FORMULA, repeatable |
--sheet |
Worksheet name (required) |
--value |
Value to write into --cell |
Check the result
Read each important changed cell, recalculate cached formulas when necessary, and compare totals before PDF export.
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 set --help to compare options with your installed version.
See the excel command reference for the surrounding workflow.