edit_spreadsheet
Write cell values or append rows to .xlsx or .csv spreadsheet files. Use A1 notation for targeted updates, add new rows, or create the file if needed.
Instructions
Write cells or append rows to a spreadsheet file (.xlsx or .csv). 'updates' is a list of {cell, value} objects using A1 notation (e.g. {"cell": "B3", "value": 500}). 'append_rows' is a list of rows (each row is a list of values) to add at the end. Set create_if_missing=true to create the file if it does not exist (.xlsx only). Requires allow_file_write in ~/.syscontrol/config.json.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Path to the .xlsx or .csv file. | |
| sheet | No | Sheet name to edit (.xlsx only). Defaults to the active sheet. | |
| updates | No | List of cell updates: [{"cell": "A1", "value": "Hello"}, ...]. | |
| append_rows | No | Rows to append at the end of the sheet: [["Q1", 1000], ["Q2", 2000]]. | |
| create_if_missing | No | Create the file if it does not exist (.xlsx only). Default false. |