Notes and comments
xlide_manage_commentManage Excel cell comments: read notes and threaded conversations, add or update notes, reply to threads, resolve them, or remove comments from a worksheet.
Instructions
Lists, writes, answers or removes the comments on a worksheet's cells. Excel has two kinds: a note, the yellow box that shows on hover, and a threaded comment, the conversation on the Review tab with replies and a resolved state. action='list' reads both and changes nothing. 'set' writes a note, replacing one already on the cell, or with kind='thread' starts a conversation; 'reply' and 'resolve' act on a thread; 'remove' takes either kind off the cell. Use a note to explain a cell to whoever reads the workbook next.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cell | No | The cell, such as B4. For list, empty lists the sheet. | |
| kind | No | For set: 'note' or 'thread'. | note |
| text | No | For set and reply: what the comment says. | |
| sheet | Yes | Worksheet name, matched without case. | |
| action | No | list, set, reply, resolve or remove. | list |
| author | No | Who wrote it, as the workbook shows the name. | Agent |
| visible | No | For a note: shown all the time, not only on hover. | |
| resolved | No | For resolve: false opens a thread again. | |
| file_path | Yes | Absolute path to the Excel file. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||