office_sheet_tool
Edit XLSX or ODS workbooks by listing, adding, reading, and setting sheets, cells, formulas, hyperlinks, and defined names, then save changes directly to disk.
Instructions
Edit an xlsx or ods workbook: sheets, cells, formulas, and links.
action is list, add, read, set, formula, link, or name. sheet is the sheet name. cell looks like A1. formula is Excel-like, including a link to another sheet such as =Other!A1. link is a hyperlink, for example https://example.com or #'Other'!A1. name creates an xlsx defined name; range_ref looks like Sheet1!$A$1:$B$10. list and read return values and formulas.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cell | No | ||
| link | No | ||
| path | Yes | ||
| sheet | No | ||
| value | No | ||
| action | Yes | ||
| formula | No | ||
| range_ref | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |