officecli-xlsx

You can automate Excel workbook manipulation via a CLI to programmatically create, read, update, format, and validate single- or multi-sheet .xlsx files. This approach replaces manual spreadsheet edits with scriptable commands.

Yes, creating workbooks with charts and named ranges is supported via the CLI. You can programmatically structure multi-sheet workbooks and add cross-sheet references without opening a graphical interface.

You can batch update and validate .xlsx files programmatically using the batch command. This automates QA and validation workflows across multiple workbooks to accelerate data-analytics tasks.

No external dependencies are required to process workbooks. The Skill operates independently with commands like create, add, set, get, and view to manipulate cell values and formulas.

The best way to read and modify cell formulas across multiple sheets is using the CLI's get and set commands. This enables programmatic parsing and updating of cross-sheet references within .xlsx files.

Processing .xlsx files via command-line scripting is limited to standard workbook structures, including sheets, charts, and named ranges. Complex embedded objects or proprietary formats are not explicitly supported.