set_cell_value
Update spreadsheet cell values using row and column coordinates to modify CSV data programmatically. Specify target cell by index or name and set new value with automatic change tracking.
Instructions
Set value of specific cell with coordinate targeting.
Supports column name or index, tracks old and new values. Returns operation result with coordinates and data type.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| row_index | Yes | Row index (0-based) to update cell in | |
| column | Yes | Column name or column index (0-based) to update | |
| value | Yes | New value to set in the cell (str, int, float, bool, or None) |
Input Schema (JSON Schema)
{
"properties": {
"column": {
"anyOf": [
{
"type": "string"
},
{
"type": "integer"
}
],
"description": "Column name or column index (0-based) to update"
},
"row_index": {
"description": "Row index (0-based) to update cell in",
"type": "integer"
},
"value": {
"anyOf": [
{
"type": "string"
},
{
"type": "integer"
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
],
"description": "New value to set in the cell (str, int, float, bool, or None)"
}
},
"required": [
"row_index",
"column",
"value"
],
"type": "object"
}