write_cells
Write values, fill series, and merge or unmerge cell ranges in Excel worksheets. Choose from single-cell, range, series, merge, or unmerge modes to modify workbook data directly.
Instructions
Write data or operations to worksheet cells.
Args:
mode: One of "single", "range", "series", "merge", or "unmerge".
- "single": write a single cell. Requires cell_ref and value.
- "range": write a 2D array starting at start_cell. Requires start_cell and data.
- "series": fill a series from start_cell. Requires start_cell and count.
- "merge": merge a cell range. Requires range_string.
- "unmerge": unmerge a cell range. Requires range_string.
file_path: Path to workbook to mutate.
sheet_name: Target worksheet name.
cell_ref: Single-cell reference for "single" and some formula operations.
value: Value to write for single-cell writes.
start_cell: Top-left cell for range/series writes.
data: 2D array of values for "range" mode.
series_type: Series type for "series" (e.g. "number").
count: Number of series entries to write (required for "series").
step: Increment for numeric series or string step expression.
direction: "down" or "right" for series growth.
start_value: Optional starting value for series.
range_string: Range string for merge/unmerge (e.g. "A1:D1").
Returns: str or dict: Success message or structured result depending on operation.
Raises:
ValueError: If required parameters for the chosen mode are missing or mode is unknown.
Notes:
- This route mutates workbook files (destructive operations).
- Dispatch mapping: "single"→tools.cell_ops.write_cell, "range"→tools.cell_ops.write_range,
"series"→tools.cell_ops.fill_series, "merge"→tools.cell_ops.merge_cells, "unmerge"→tools.cell_ops.unmerge_cells.
- Recommend adding short examples in the underlying tools for common series patterns.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | No | ||
| mode | Yes | ||
| step | No | ||
| count | No | ||
| value | No | ||
| cell_ref | No | ||
| direction | No | down | |
| file_path | Yes | ||
| sheet_name | Yes | ||
| start_cell | No | ||
| series_type | No | number | |
| start_value | No | ||
| range_string | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |