Jetformat

Protect an Excel worksheet

Use jetformat excel protect-sheet to protect an Excel worksheet.

By Jetformat

Select the worksheet to protect. This differs from protecting workbook structure and should not be described as encrypting the XLSX file.

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 protect-sheet finance.xlsx --sheet Summary --password secret -o finance-updated.xlsx

Options for this task

Option Meaning
--output Output XLSX path (required)
--password Optional password
--sheet Worksheet name (required)

Check the result

Open the saved sheet and check editing restrictions in the viewer that recipients will use.

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

See the excel command reference for the surrounding workflow.

Last updated