write_cells
Write values to Excel cells or ranges in live workbooks or .xlsx files without needing Excel installed. Supports single values, arrays, or 2D arrays while preserving existing content.
Instructions
Write values to a cell or range. Use "workbook" for live Excel, or "path" for a .xlsx file on disk (no Excel needed, preserves images/charts). Accepts a single value, a flat array, or a 2D array.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| workbook | No | Open workbook name (live Excel) | |
| path | No | File path to .xlsx (no Excel needed) | |
| range | Yes | Cell range (e.g. "A1" or "A1:B5") | |
| value | Yes | Value(s) to write | |
| sheet | No | Sheet name (default: active sheet) |