Excel
Microsoft Excel is a powerful spreadsheet application for data analysis, calculations, and visualization, enabling users to organize and process data with formulas, charts, and pivot tables
Sign in with one click. Composio asks the app for you; Quilt never sees the login.
Reads on its own64
Agents use these right away.
- List Table ColumnsList columns in a table using Microsoft Graph API.
- Search Drive FilesSearch OneDrive drive items by query and return files, optionally filtered by extension, to discover Excel workbook IDs.
- Who Am IReturn the identity (email, name) of the connected Excel (Microsoft) account.
- Calculate Workbook FunctionRun one allowlisted Microsoft Graph v1.0 workbook function.
- Download WorkbookDownload an Excel workbook in its original file format.
- Export Workbook to PDFExport an Excel workbook to PDF using Microsoft Graph format conversion, returning a download URL.
- Get Excel ApplicationGet Excel Application
- Get chartGet chart
- Get Chart AxisTool to retrieve a specific axis from a chart.
- Get chart componentRetrieve one Excel chart component: chart title, axis title, supported gridlines, axis font, or supported line format.
- Get Chart Data LabelsTool to retrieve the data labels object of a chart.
- Get chart imageRender an Excel chart as a base64-encoded image.
- Get Chart LegendTool to retrieve the legend object of a chart.
- Get chart pointGet chart point
- Get chart seriesGet chart series
- Get CommentRetrieve one workbook comment by its exact ID.
- Get Comment ReplyRetrieve one reply to a workbook comment by its exact ID.
- Get Derived RangeReturn a range derived from another range by navigation or geometry.
- Get Drive ItemRetrieve OneDrive or SharePoint drive item metadata by exact ID or path.
- Get Named ItemRetrieve a workbook-scoped named item by exact name.
- Get Named Item RangeRetrieve the Excel range of a range-valued workbook-scoped named item.
- Get Excel Operation StatusGet the status of an asynchronous Excel workbook operation by its operation ID.
- Get Pivot TableGet Pivot Table
- Get Projected Worksheet SubresourceRead selected properties from a worksheet range, its used range, or worksheet protection.
- Get RangeGet a range from a worksheet using Microsoft Graph API.
- Get Range FormatRead one formatting component from a workbook range.
- Get SharePoint RangeGet a range from a worksheet in SharePoint using Microsoft Graph Sites API.
- Get SharePoint WorksheetGet a worksheet by name or ID from an Excel workbook in a SharePoint site's default drive using Microsoft Graph.
- Get TableRetrieve one workbook- or worksheet-addressed table by ID or exact name.
- Get table columnTool to retrieve a specific column from a workbook table.
- Get Table Column CellRead one cell by row within a selected table column's data body.
- Get Table Column RangeGet Table Column Range
- Get Table RangeGet Table Range
- Get Table RowGet Table Row
- Get Table Row RangeGet Table Row Range
- Get Table SortGet Table Sort
- Get Visible RangeRead cells visible after worksheet filtering.
- Get workbookRetrieve a workbook's relationships, including comments, named items, operations, tables, and worksheets, with optional relationship expansion.
- Get WorksheetGet a worksheet by name or ID from an Excel workbook using Microsoft Graph API.
- Get Worksheet ProtectionGet Worksheet Protection
- Get Worksheet Row RangeRead a zero-based worksheet row across the column bounds of the worksheet's values-only used range.
- Get Worksheet Used RangeTool to retrieve a worksheet's used range (active data region) without specifying a fixed range address.
- List chart pointsList chart points
- List ChartsList charts in a worksheet using Microsoft Graph API.
- List Chart SeriesList a page of data series names in a chart, with a next-page link when more results are available.
- List Comment RepliesList replies to one workbook comment.
- List CommentsList a page of comments in an Excel workbook using Microsoft Graph.
- List Drive Item ChildrenTool to list immediate children (files/folders) of a folder DriveItem using driveId and itemId.
- List Drive Item VersionsList retained versions of a OneDrive or SharePoint workbook file.
- List Drive FilesList files and folders in a drive root or specified path.
- List Named ItemsList named items in a workbook using Microsoft Graph.
- List Pivot TablesList Pivot Tables
- List SharePoint TablesList tables in a worksheet of an Excel workbook stored in a SharePoint site's default drive using Microsoft Graph.
- List SharePoint WorksheetsList worksheets in an Excel workbook stored in SharePoint using Microsoft Graph Sites API.
- List Site ListsList SharePoint lists in a known Microsoft Graph site.
- List Table RowsList rows in a table using Microsoft Graph API.
- List TablesList tables in a specified Excel worksheet using Microsoft Graph API.
- List Workbook PermissionsTool to list permissions set on the workbook file.
- List Workbook TablesList tables across a workbook without requiring a worksheet identifier.
- List WorksheetsList worksheets in an Excel workbook using Microsoft Graph API.
- Resolve Shared WorkbookResolve a Microsoft Graph share token, shareId, or raw sharing URL to DriveItem metadata.
- Run Graph Read BatchRead drive or workbook data in up to 20 GET requests; inspect every subresponse status because individual requests can fail.
- Search Microsoft 365 ContentSearch OneDrive and SharePoint content using Microsoft Search.
- Search SitesSearch SharePoint sites by free-text query for workbook discovery.
Asks someone first61
Anything that sends, creates, changes or deletes waits for a person to approve it in the session’s chat.
- Add TableCreate a new table in a worksheet using the Microsoft Graph API.
- Add Workbook PermissionTool to grant access to a workbook via invite.
- Create Excel SessionCreate a session for an Excel workbook using Microsoft Graph API.
- Insert RangeTool to insert a new cell range into a worksheet, shifting existing cells down or right.
- Add ChartAdd a chart to a worksheet using Microsoft Graph API.
- Add Named ItemAdd a workbook- or worksheet-scoped named item using an invariant reference or a local formula.
- Add SharePoint WorksheetAdd a new worksheet to an Excel workbook in a SharePoint site's default drive using Microsoft Graph.
- Add Table ColumnAdd a column to a table using Microsoft Graph API.
- Add Table RowAdd a row to a table using Microsoft Graph API.
- Add WorksheetAdd a new worksheet to an Excel workbook using Microsoft Graph API.
- Apply Table FilterApply a filter to a table column using Microsoft Graph API.
- Apply Table SortApply a sort to a table using Microsoft Graph API.
- Autofit RangeAutofit columns or rows intersecting a workbook range.
- Calculate Excel WorkbookCalculate Excel Workbook
- Clear RangeTool to clear values, formats, or contents in a specified worksheet range.
- Clear Table FilterClear a filter from a table column using Microsoft Graph API.
- Clear All Table FiltersClear All Table Filters
- Clear Table SortClear Table Sort
- Close Excel SessionTool to close an existing Excel workbook session.
- Convert Table To RangeConvert a table to a range using Microsoft Graph API.
- Copy Drive ItemCreate a non-destructive asynchronous copy of a file or folder.
- Create CommentCreate a plain-text Excel cell comment through Microsoft Graph beta.
- Create FolderCreate a folder under a parent Microsoft Graph drive item.
- Create Upload SessionCreate a resumable upload session at a drive-root path.
- Create WorkbookTool to create a new Excel workbook file at a specified drive path.
- Create Workbook Sharing LinkCreate or retrieve an application-owned sharing link for a workbook.
- Delete Drive ItemMove a OneDrive or SharePoint drive item to the recycle bin by item ID.
- Delete Named ItemPermanently delete a workbook-scoped named item; this cannot be undone.
- Delete RangeDelete worksheet cells and shift the remaining cells up or left.
- Delete TablePermanently delete an Excel table by its ID or name.
- Delete Table ColumnDelete a column from a table using Microsoft Graph API.
- Delete Table RowDelete a row from a table using Microsoft Graph API.
- Delete WorksheetTool to delete a worksheet from the workbook.
- Merge CellsMerge cells in a worksheet range using Microsoft Graph API.
- Protect WorksheetTool to protect a worksheet using optional protection options.
- Reapply All Table FiltersReapply All Table Filters
- Reapply Table SortReapply Table Sort
- Refresh Pivot TablesRefresh Pivot Tables
- Refresh Excel SessionRefresh Excel Session
- Revoke Workbook PermissionRemove a non-inherited sharing permission from a workbook.
- 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.
- Set chart dataReplace an Excel chart's source range and optionally choose whether rows or columns define its series.
- Set chart positionSet chart position
- Sort RangeSort a range in a worksheet using Microsoft Graph API.
- Unmerge RangeSplit a merged worksheet range back into separate cells.
- Unprotect WorksheetRemove protection from a worksheet so it can be edited again.
- Update ChartUpdate a chart in a worksheet using Microsoft Graph API.
- Update chart componentUpdate one Excel chart component: an axis, data labels, chart title, axis title, supported gridlines, axis font, fill, or supported line format.
- Update Chart LegendUpdate a chart legend's visibility, position, or overlay setting.
- Update chart seriesRename one Excel chart series by ID or zero-based collection position.
- Update Drive ItemRename, move within the same drive, or update client timestamps for a DriveItem by stable ID.
- Update Named ItemUpdate a workbook named item's visibility or comment.
- Update RangeUpdate cell values in a specified worksheet range using Microsoft Graph API.
- Update Range FormatUpdate exactly one formatting component on a workbook range.
- Update SharePoint RangeUpdate values in a worksheet range in an Excel workbook stored in a SharePoint site's default drive using Microsoft Graph.
- Update TableUpdate an Excel workbook table's name, header visibility, totals visibility, or style using Microsoft Graph.
- Update Table ColumnUpdate the name or values of an Excel table column.
- Update Table Column RangeUpdate raw values in a table column's data-body cells by zero-based index.
- Update Table RowUpdate Table Row
- Update WorksheetUpdate worksheet properties (name, position) in an Excel workbook using Microsoft Graph API.
- Upload Workbook from URLTool to upload an external Excel file from a URL into OneDrive/SharePoint.