Composio powers 1000+ toolkits, tool search, context management, authentication, and a sandboxed workbench to help you build AI agents that turn intent into action.

next
md 42 lines 2.13 KB
Rendered Raw
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.