set_cells
Write up to 200 cell values or formulas to a sheet in one atomic transaction, so all changes undo as a single step.
Instructions
Write one or more arbitrary cells on a sheet in a single atomic transaction (one undo step). Each cell is addressed by zero-based row/col. Content is a literal (string / number / boolean) or a formula prefixed with '='. null or '' clears the cell. For cells that belong to a block, prefer edit set_block_cells (it respects the schema); use this for plain, non-block cells. At most 200 cells per call.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cells | Yes | ||
| sheetIdx | Yes | Zero-based sheet index. |