Create a named range in Excel

By Jetformat

Use an explicit worksheet reference for the new name. Quote references containing dollar signs in the shell so absolute cell references survive unchanged.

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 add-name finance.xlsx --name Revenue --ref 'Summary!$B$2' -o named.xlsx

Options for this task

Option	Meaning
`--name`	Name
`--output`	Output XLSX path (required)
`--ref`	Reference, for example Summary!$A$1

Check the result

Run excel names on the saved workbook and compare the name and reference.

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 add-name --help to compare options with your installed version.

See the excel command reference for the surrounding workflow.