skill-excel-io

You can read and edit Excel files from the command line using a Python-based CLI that supports sheet selection, cell ranges, and batch updates. It enables reading, editing, and writing operations directly without manual scripting.

Yes, you can convert Excel data to CSV or JSON using the CLI. It supports reading specific sheets or ranges and outputting the data in Markdown, JSON, or CSV formats for easy consumption and export.

You can batch update Excel cell values and formatting by defining an ops.json file. The CLI applies these batch edits including bold, color, borders, and number formats safely in-place without needing to open Excel manually.

Yes, you need openpyxl installed as it powers the CLI's ability to manipulate xlsx files. This dependency handles the underlying read, write, and sheet manipulation operations for Excel workbooks.

The best way to write JSON or CSV data into an existing Excel workbook is using the CLI's write functionality. It supports importing data from CSV or JSON sources and can append data or manipulate sheets directly.

When using openpyxl for CLI Excel manipulation, operations are deterministic and token-efficient but focus on standard xlsx formats. It handles safe in-place edits and sheet manipulation but does not process legacy xls files.