Jetformat

Set an Excel worksheet header and footer

Use jetformat excel header-footer to set an Excel worksheet header and footer.

By Jetformat

This command reads or writes centered header and footer text. The text belongs to print layout rather than worksheet cells.

Steps

  1. Start with a local XLSX. Replace the sample paths and identifiers with your own.
  2. Run the command below. Save to a new output path so the source remains available for comparison.
  3. Check the result as described below before using it in another job.
jetformat excel header-footer finance.xlsx --sheet Summary --header Title --footer Page -o finance-updated.xlsx

Options for this task

Option Meaning
--footer Centered footer
--header Centered header
--output Output XLSX; omit to print only
--sheet Worksheet name (required)

Check the result

Read the header/footer again and inspect the converted PDF to confirm print placement.

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

See the excel command reference for the surrounding workflow.

Last updated