Jetformat

Inspect workbook structure before processing data

A workbook filename does not reveal its sheet structure. Inspection gives a script a concrete view of the workbook before selecting cells or modifying tabs.

Published · 2 min read

By allentatakai

Decide what success means

Use the inventory to choose specific sheet operations. Structural inspection does not calculate business metrics or establish that the workbook’s formulas are current.

Prepare and run

Start with the exact input file for the job. Record sheet names rather than assuming every workbook uses a tab called Summary.

These examples use local sample filenames. Substitute your own paths and check jetformat excel inspect --help against the installed version before running the task. Put paths containing spaces inside quotes.

jetformat excel inspect finance.xlsx --json

Use structural inspection before selecting a worksheet or editing cells. The output summarizes sheet ranges and counts of formulas, charts, and images.

Inspect the saved result

Record the exact sheet name and used range; a chart count does not mean charts will render in PDF.

Scope and repeatability

This is a free utility or read operation. It does not need a paid conversion to inspect the result.

Run jetformat excel inspect --help to compare options with your installed version.

See the excel command reference for the surrounding workflow.

Keep the input revision with the result so a later reviewer can reproduce the decision. For a write operation, choose a new output path first; use overwrite flags only when replacing a previously reviewed result is intentional.

See the excel inspect options and examples for the command reference. Browse related excel commands when the next step requires a different operation.

Last updated