excel

to-pdf (1 credit per output page)

jetformat excel to-pdf workbook.xlsx -o workbook.pdf

Visible worksheets become one PDF in workbook order. Hidden sheets are skipped. Pages are counted on the output.

inspect, get, set, recalc, names (free)

jetformat excel inspect finance.xlsx --json
jetformat excel get finance.xlsx --sheet Summary --cell B12
jetformat excel set finance.xlsx --sheet Summary --cell A1 --value 5 -o finance.xlsx --force
jetformat excel recalc finance.xlsx -o finance.xlsx --force
jetformat excel names finance.xlsx

set writes a value or formula. recalc updates cached results, which files written by openpyxl and similar libraries lack.

Layout and structure (free)

jetformat excel table finance.xlsx --sheet Summary --range A1:B2 --name Sales -o finance.xlsx --force
jetformat excel sort finance.xlsx --sheet Summary --column A --order asc -o finance.xlsx --force
jetformat excel filter finance.xlsx --sheet Summary --range A1:C20 -o finance.xlsx --force
jetformat excel freeze finance.xlsx --sheet Summary --row --col -o finance.xlsx --force
jetformat excel merge-cells finance.xlsx --sheet Summary --from A1 --to B1 -o finance.xlsx --force
jetformat excel insert-row finance.xlsx --sheet Summary --row 2 -o finance.xlsx --force
jetformat excel add-row finance.xlsx --sheet Summary -o finance.xlsx --force
jetformat excel hide-column finance.xlsx --sheet Summary --column A -o finance.xlsx --force
jetformat excel column-width finance.xlsx --sheet Summary --column A --width 18 -o finance.xlsx --force
jetformat excel print-area finance.xlsx --sheet Summary --range A1:B2 -o finance.xlsx --force
jetformat excel header-footer finance.xlsx --sheet Summary --header Title --footer Page -o finance.xlsx --force
jetformat excel validation finance.xlsx --sheet Summary --range A2:A10 --list Ada,Bob -o finance.xlsx --force
jetformat excel hyperlink finance.xlsx --sheet Summary --cell A1 --url https://jetformat.com -o finance.xlsx --force
jetformat excel comment finance.xlsx --sheet Summary --cell A2 --text "check qty" -o finance.xlsx --force

Sheets and protection (free)

jetformat excel add-sheet finance.xlsx --name Extra -o finance.xlsx --force
jetformat excel copy-sheet finance.xlsx --from Summary --name Copy -o finance.xlsx --force
jetformat excel rename finance.xlsx --sheet Summary --name Report -o finance.xlsx --force
jetformat excel remove-sheet finance.xlsx --sheet Extra -o finance.xlsx --force
jetformat excel protect finance.xlsx --password secret -o finance.xlsx --force
jetformat excel protect-sheet finance.xlsx --sheet Summary --password secret -o finance.xlsx --force
jetformat excel unprotect finance.xlsx -o finance.xlsx --force

merge, split, extract-images (free)

jetformat excel merge a.xlsx b.xlsx -o workbook.xlsx --force
jetformat excel split workbook.xlsx -o workbook-parts --force
jetformat excel extract-images finance.xlsx -o finance-images

Merge copies values and formulas from visible sheets. Charts and images may not copy.

Limits

No .xls or .xlsm. Charts inside sheets are not rendered in the PDF yet. Number formats on recalculated cells are not applied yet. There is no delete-row command.