- Category: spreadsheets
- Auth: OAUTH2, S2S_OAUTH2
- Composio-managed OAuth available? Yes
- Tools: 125
- Triggers: 0
- Slug:
EXCEL - Version: 20261103_00
Tools
Add Chart
Add Chart
Add Named Item
Add Named Item
Add Table
Add Table
EXCEL_ADD_TABLECreate a new table in a worksheet using the Microsoft Graph API.Input Parameters
Output
Add Table Column
Add Table Column
EXCEL_ADD_TABLE_COLUMNAdd a column to a table using Microsoft Graph API.Input Parameters
Output
Add Table Row
Add Table Row
EXCEL_ADD_TABLE_ROWAdd a row to a table using Microsoft Graph API.Input Parameters
Output
Add Workbook Permission
Add Workbook Permission
EXCEL_ADD_WORKBOOK_PERMISSIONTool to grant access to a workbook via invite. Use when you need to share a specific workbook file with designated recipients and roles.Input Parameters
Output
Add Worksheet
Add Worksheet
Apply Table Filter
Apply Table Filter
Apply Table Sort
Apply Table Sort
Autofit Range
Autofit Range
Calculate Workbook Function
Calculate Workbook Function
EXCEL_CALCULATE_FUNCTIONRun one allowlisted Microsoft Graph v1.0 workbook function.Input Parameters
Output
Calculate Excel Workbook
Calculate Excel Workbook
Clear Range
Clear Range
EXCEL_CLEAR_RANGETool to clear values, formats, or contents in a specified worksheet range. Use when you need to reset cells before adding new data.Input Parameters
Output
Clear Table Filter
Clear Table Filter
Close Excel Session
Close Excel Session
EXCEL_CLOSE_SESSIONTool to close an existing Excel workbook session. Use when you need to explicitly end a persistent session to release workbook locks. Note: The Microsoft Graph closeSession API is idempotent - it returns 204 for both active and already-closed sessions. This action validates the session first and returns an error for invalid or already-closed sessions to provide clearer user feedback. The validation uses refreshSession which is the only API endpoint that can detect closed sessions.Input Parameters
Output
Convert Table To Range
Convert Table To Range
EXCEL_CONVERT_TABLE_TO_RANGEConvert a table to a range using Microsoft Graph API.Input Parameters
Output
Copy Drive Item
Copy Drive Item
Create Comment
Create Comment
Create Folder
Create Folder
Create Upload Session
Create Upload Session
Create Workbook
Create Workbook
EXCEL_CREATE_WORKBOOKTool to create a new Excel workbook file at a specified drive path. Generates a new .xlsx file with specified worksheets and data, then uploads it to OneDrive.Input Parameters
Output
Create Workbook Sharing Link
Create Workbook Sharing Link
EXCEL_CREATE_WORKBOOK_SHARING_LINKCreate or retrieve an application-owned sharing link for a workbook.Input Parameters
anonymous: anyone with the link can use it; choose it only when the user explicitly asks for anonymous or ‘anyone with the link’ access, never by inference. organization: people signed in to the tenant. If omitted, Microsoft Graph applies the administrator-defined default scope, which may be anonymous. User-specific links require a separate recipient grant and are not supported by this action.Output
Delete Drive Item
Delete Drive Item
Delete Named Item
Delete Named Item
Delete Range
Delete Range
Delete Table
Delete Table
Delete Table Column
Delete Table Column
Delete Table Row
Delete Table Row
Delete Worksheet
Delete Worksheet
EXCEL_DELETE_WORKSHEETTool to delete a worksheet from the workbook. Use when cleaning up unused or temporary sheets after verifying no dependencies exist. Example: “Delete ‘Sheet2’ after review.”Input Parameters
Output
Download Workbook
Download Workbook
Export Workbook to PDF
Export Workbook to PDF
EXCEL_EXPORT_WORKBOOK_TO_PDFExport an Excel workbook to PDF using Microsoft Graph format conversion, returning a download URL. Optionally save the converted PDF to a path in the selected drive.Input Parameters
Output
Get Chart Axis
Get Chart Axis
EXCEL_GET_CHART_AXISTool to retrieve a specific axis from a chart. Use when you need properties like min, max, interval, and formatting of the chart axis.Input Parameters
Output
Get chart component
Get chart component
Get Chart Data Labels
Get Chart Data Labels
EXCEL_GET_CHART_DATA_LABELSTool to retrieve the data labels object of a chart. Use when you need to inspect label settings like position, separator, and visibility flags after creating or updating a chart.Input Parameters
Output
Get chart image
Get chart image
Get Chart Legend
Get Chart Legend
EXCEL_GET_CHART_LEGENDTool to retrieve the legend object of a chart. Use after creating or updating a chart when you need to inspect legend visibility and formatting.Input Parameters
Output
Get Comment
Get Comment
Get Comment Reply
Get Comment Reply
Get Derived Range
Get Derived Range
EXCEL_GET_DERIVED_RANGEReturn a range derived from another range by navigation or geometry.Input Parameters
Output
Get Drive Item
Get Drive Item
Get Named Item
Get Named Item
Get Named Item Range
Get Named Item Range
Get Excel Operation Status
Get Excel Operation Status
Get Projected Worksheet Subresource
Get Projected Worksheet Subresource
Get Range
Get Range
EXCEL_GET_RANGEGet a range from a worksheet using Microsoft Graph API.Input Parameters
Output
Get Range Format
Get Range Format
EXCEL_GET_RANGE_FORMATRead one formatting component from a workbook range.Input Parameters
Output
Create Excel Session
Create Excel Session
EXCEL_GET_SESSIONCreate a session for an Excel workbook using Microsoft Graph API.Input Parameters
Output
Get Table
Get Table
Get table column
Get table column
EXCEL_GET_TABLE_COLUMNTool to retrieve a specific column from a workbook table. Use when you need to fetch column properties and data by its ID or name.Input Parameters
Output
Get Table Column Cell
Get Table Column Cell
Get Table Column Range
Get Table Column Range
Get Visible Range
Get Visible Range
Get workbook
Get workbook
EXCEL_GET_WORKBOOKRetrieve a workbook’s relationships, including comments, named items, operations, tables, and worksheets, with optional relationship expansion.Input Parameters
Output
Get Worksheet
Get Worksheet
EXCEL_GET_WORKSHEETGet a worksheet by name or ID from an Excel workbook using Microsoft Graph API.Input Parameters
Output
Get Worksheet Protection
Get Worksheet Protection
Get Worksheet Row Range
Get Worksheet Row Range
Get Worksheet Used Range
Get Worksheet Used Range
EXCEL_GET_WORKSHEET_USED_RANGETool to retrieve a worksheet’s used range (active data region) without specifying a fixed range address. Use when you need to read all data from a sheet but don’t know the exact range. The valuesOnly option helps filter out formatting-only cells.Input Parameters
Output
Insert Range
Insert Range
EXCEL_INSERT_RANGETool to insert a new cell range into a worksheet, shifting existing cells down or right. Use when you need to create space for new content without overwriting.Input Parameters
Output
List Charts
List Charts
EXCEL_LIST_CHARTSList charts in a worksheet using Microsoft Graph API.Input Parameters
Output
List Chart Series
List Chart Series
EXCEL_LIST_CHART_SERIESList a page of data series names in a chart, with a next-page link when more results are available.Input Parameters
Output
List Comment Replies
List Comment Replies
List Comments
List Comments
List Drive Item Children
List Drive Item Children
EXCEL_LIST_DRIVE_ITEM_CHILDRENTool to list immediate children (files/folders) of a folder DriveItem using driveId and itemId. Returns an array of child DriveItems with stable identifiers and pagination support.Input Parameters
Output
List Drive Item Versions
List Drive Item Versions
EXCEL_LIST_DRIVE_ITEM_VERSIONSList retained versions of a OneDrive or SharePoint workbook file.Input Parameters
Output
List Drive Files
List Drive Files
EXCEL_LIST_FILESList files and folders in a drive root or specified path.Input Parameters
Output
List Named Items
List Named Items
EXCEL_LIST_NAMED_ITEMSList named items in a workbook using Microsoft Graph. If no session is supplied, the tool creates a nonpersistent workbook session before listing.Input Parameters
Output
List Site Lists
List Site Lists
EXCEL_LIST_SITE_LISTSList SharePoint lists in a known Microsoft Graph site. Use site search first when the site ID is unknown. The action exposes projection and page controls but does not automatically follow the returned next link.Input Parameters
Output
List Table Columns
List Table Columns
List Table Rows
List Table Rows
EXCEL_LIST_TABLE_ROWSList rows in a table using Microsoft Graph API.Input Parameters
Output
List Tables
List Tables
EXCEL_LIST_TABLESList tables in a specified Excel worksheet using Microsoft Graph API. Returns one page of table information and a continuation link when provided; an optional workbook session can be used.Input Parameters
Output
List Workbook Permissions
List Workbook Permissions
EXCEL_LIST_WORKBOOK_PERMISSIONSTool to list permissions set on the workbook file. Use when you need to see which users or links have access to a specific Excel file by supplying its drive and item IDs. Example: “List permissions for workbook with drive_id ‘b!abc123’ and item_id ‘0123456789abcdef’.”Input Parameters
Output
List Workbook Tables
List Workbook Tables
List Worksheets
List Worksheets
Merge Cells
Merge Cells
EXCEL_MERGE_CELLSMerge cells in a worksheet range using Microsoft Graph API.Input Parameters
Output
Protect Worksheet
Protect Worksheet
EXCEL_PROTECT_WORKSHEETTool to protect a worksheet using optional protection options. Use when you need to prevent editing certain parts of a sheet before sharing. Example: “Protect ‘Sheet1’ to lock formatting and sorting.”Input Parameters
Output
Reapply All Table Filters
Reapply All Table Filters
Revoke Workbook Permission
Revoke Workbook Permission
EXCEL_REVOKE_WORKBOOK_PERMISSIONRemove a non-inherited sharing permission from a workbook.Input Parameters
Output
Run Graph Mutation Batch
Run Graph Mutation Batch
EXCEL_RUN_GRAPH_MUTATION_BATCHCreate, update, or delete drive or workbook resources in up to 20 requests; inspect every subresponse status because individual mutations can fail.Input Parameters
Output
Run Graph Read Batch
Run Graph Read Batch
Search Drive Files
Search Drive Files
EXCEL_SEARCH_FILESSearch OneDrive drive items by query and return files, optionally filtered by extension, to discover Excel workbook IDs. Extension filtering is applied to each returned page.Input Parameters
Output
Search Microsoft 365 Content
Search Microsoft 365 Content
Search Sites
Search Sites
Set chart data
Set chart data
Sort Range
Sort Range
EXCEL_SORT_RANGESort a range in a worksheet using Microsoft Graph API.Input Parameters
Output
Unmerge Range
Unmerge Range
Unprotect Worksheet
Unprotect Worksheet
Update Chart
Update Chart
Update chart component
Update chart component
Update Chart Legend
Update Chart Legend
EXCEL_UPDATE_CHART_LEGENDUpdate a chart legend’s visibility, position, or overlay setting.Input Parameters
Output
Update chart series
Update chart series
Update Drive Item
Update Drive Item
Update Named Item
Update Named Item
Update Range
Update Range
EXCEL_UPDATE_RANGEUpdate cell values in a specified worksheet range using Microsoft Graph API.Input Parameters
Output
Update Range Format
Update Range Format
Update Table
Update Table
Update Table Column
Update Table Column
Update Table Column Range
Update Table Column Range
Update Worksheet
Update Worksheet
EXCEL_UPDATE_WORKSHEETUpdate worksheet properties (name, position) in an Excel workbook using Microsoft Graph API.Input Parameters
Output
Upload Workbook from URL
Upload Workbook from URL
EXCEL_UPLOAD_WORKBOOKTool to upload an external Excel file from a URL into OneDrive/SharePoint. Downloads the file server-side and uploads it to the specified drive location, returning the driveItem metadata for subsequent Excel operations.