Excel Write Cell
excel_write_cellDestructive
Writes a value to a specific cell in an Excel file. Numeric-looking value strings are written as numbers only when they round-trip exactly; otherwise they stay text. A value that starts with = is written as a formula (e.g. "=SUM(B2:B3)"), computed when the file is opened; start it with an apostrophe to keep it as text. A formula that reaches outside the file or runs code (WEBSERVICE, IMAGE, HYPERLINK, STOCKHISTORY, TRANSLATE, COPILOT, PY, CUBE…, CALL, REGISTER, EXEC, IMPORT…, RTD, DDE or a |, or a reference to another workbook by name, path or URL) is refused and nothing is written. Address the cell either with cell in A1 notation (e.g. "B2") or with row+column as 1-based integers.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| row | No | Row number (1-based) — use with `column`, or use `cell` instead | |
| cell | No | Cell in A1 notation, e.g. "B2" (alternative to row+column) | |
| path | Yes | Path to the .xlsx file | |
| value | Yes | Value to write | |
| column | No | Column number (1-based) — use with `row`, or use `cell` instead | |
| confirm | No | Must be true to modify | |
| sheet_name | No | Sheet name (default: first sheet). Matched without case. A name that no sheet has is an error listing the available ones — it never falls back to the first sheet. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| col | Yes | Column that was written (1-based) | |
| row | Yes | Row that was written (1-based) | |
| sheet | No | Sheet the value actually landed in | |
| value | Yes | Value written to the cell | |
| written | Yes | True when the cell was written |