officecli-xlsx

Use officecli create to make the file, then officecli set to write values and formulas such as SUM(B2:B4) with number formats in one call. Finish with officecli close and officecli validate to confirm the workbook has no errors.

Run officecli import with the target sheet, the CSV file path, and the --header flag to add AutoFilter and freeze the header row. Column widths and number formats still need a follow-up pass with officecli set.

Yes, the officecli tool itself is cross-platform and installs on Windows via an install.ps1 script. However, the shell snippets in this Skill are written for bash/zsh, so on Windows you must translate syntax like heredocs, &&, and grep into PowerShell equivalents.

Shells mangle the exclamation mark in references like Sheet1!A1 into a backslash-escaped form, silently breaking the formula. Write cross-sheet formulas through a batch heredoc with a single-quoted delimiter, then verify with officecli get that the formula shows a plain exclamation mark.

Run officecli view issues, query for each error type like #REF! and #DIV/0!, then run officecli validate after closing any resident session. Also render the workbook with view html to catch clipped columns, truncated titles, and leftover placeholder tokens.

No, chart series are immutable after creation in officecli. To add or change a series, remove the chart and re-add it with the full series list; position and size remain editable via the anchor property.