set_cell_value
Update specific spreadsheet cells by row and column coordinates to modify CSV data values, tracking changes and returning operation results with data types.
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) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| success | No | Whether operation completed successfully | |
| data_type | Yes | Pandas data type of the column | |
| new_value | Yes | New cell value after update | |
| old_value | Yes | Previous cell value before update | |
| coordinates | Yes | Cell coordinates with row index and column name |