Composio powers 1000+ toolkits, tool search, context management, authentication, and a sandboxed workbench to help you build AI agents that turn intent into action.
Mirrored from https://github.com/Camo67/composio.git
Synced Nov 21, 06:00 UTC
| 1 | --- |
| 2 | type: "reference" |
| 3 | title: "Excel" |
| 4 | description: "Public support knowledge for Excel." |
| 5 | category: "authentication" |
| 6 | visibility: "public" |
| 7 | timestamp: "2026-06-24T00:00:00Z" |
| 8 | tags: |
| 9 | - "excel" |
| 10 | --- |
| 11 | # Excel |
| 12 | |
| 13 | |
| 14 | ## EXCEL_UPDATE_RANGE values must be a 2D array |
| 15 | |
| 16 | Pass values as a two-dimensional array, where the outer list represents rows and each inner list contains the cell values for that row. Even a single cell must be wrapped twice, for example {"values": [["92"]]}. |
| 17 | |
| 18 | ## Excel upload tools accept structured workbook data |
| 19 | |
| 20 | Use the revamped Excel tool shape that accepts structured data through worksheet_names and worksheet_data lists/dicts. The tool generates the .xlsx file before upload, instead of requiring the caller or LLM to provide binary workbook content directly. |
| 21 | |
| 22 | ## EXCEL_GET_RANGE failures can come from sheet name or item_id mismatches |
| 23 | |
| 24 | If get range appears to fail while the tool itself is working, verify that the workbook actually has the requested worksheet name, such as Sheet1, and that the item_id being passed is the correct file ID for that workbook. |
| 25 | |
| 26 | ## Use Excel toolkit actions for workbook operations on SharePoint-backed Excel files |
| 27 | |
| 28 | For workbook operations, use the Excel toolkit actions because they are Excel APIs. Support identified EXCEL_CLOSE_SESSION, EXCEL_DELETE_WORKSHEET, EXCEL_UPDATE_WORKSHEET, and EXCEL_UPDATE_RANGE as already supported for the remaining Excel use cases. |
| 29 | |
| 30 | ## Excel uses the Microsoft auth guide at composio.dev/auth/outlook |
| 31 | |
| 32 | For Excel auth setup, use the Microsoft auth guide published at https://composio.dev/auth/outlook. The same guide applies to SharePoint, Microsoft Teams, Outlook, and Excel. |
| 33 | |
| 34 | ## Upgrade if Excel schemas contain dollar-sign parameters |
| 35 | |
| 36 | Upgrade to the latest available release when an older Excel schema exposes |
| 37 | dollar-sign parameter names that the model provider rejects. The current schema |
| 38 | no longer uses those invalid top-level parameter names. |
| 39 | |
| 40 | ## Generic column formatting and wrapping are available in current versions |
| 41 | |
| 42 | Generic column wrapping and related sheet operations are available in the current Excel toolkit. If they are missing from the action schema, switch to the latest toolkit version. |