Excel Integration

Excel API Operations

Browse all 54 operations available for Excel workflow automation.

other

54 operations
ActionEXCEL_ADD_CHART

Add Chart

Add a chart to a worksheet using Microsoft Graph API.

7 input
ActionEXCEL_ADD_SHAREPOINT_WORKSHEET

Add SharePoint Worksheet

Add a new worksheet to a SharePoint Excel workbook using Microsoft Graph Sites API.

4 input
ActionEXCEL_ADD_TABLE

Add Table

Create a new table in a worksheet using the Microsoft Graph API.

6 input
ActionEXCEL_ADD_TABLE_COLUMN

Add Table Column

Add a column to a table using Microsoft Graph API.

6 input
ActionEXCEL_ADD_TABLE_ROW

Add Table Row

Add a row to a table using Microsoft Graph API.

6 input
ActionEXCEL_ADD_WORKBOOK_PERMISSION

Add Workbook Permission

Tool to grant access to a workbook via invite.

11 input
ActionEXCEL_ADD_WORKSHEET

Add Worksheet

Add a new worksheet to an Excel workbook using Microsoft Graph API.

4 input
ActionEXCEL_APPLY_TABLE_FILTER

Apply Table Filter

Apply a filter to a table column using Microsoft Graph API.

7 input
ActionEXCEL_APPLY_TABLE_SORT

Apply Table Sort

Apply a sort to a table using Microsoft Graph API.

6 input
ActionEXCEL_CLEAR_RANGE

Clear Range

Tool to clear values, formats, or contents in a specified worksheet range.

7 input
ActionEXCEL_CLEAR_TABLE_FILTER

Clear Table Filter

Clear a filter from a table column using Microsoft Graph API.

6 input
ActionEXCEL_CLOSE_SESSION

Close Excel Session

Tool to close an existing Excel workbook session.

3 input
ActionEXCEL_CONVERT_TABLE_TO_RANGE

Convert Table To Range

Convert a table to a range using Microsoft Graph API.

4 input
ActionEXCEL_GET_SESSION

Create Excel Session

Create a session for an Excel workbook using Microsoft Graph API.

3 input
ActionEXCEL_CREATE_WORKBOOK

Create Workbook

Tool to create a new Excel workbook file at a specified drive path.

4 input
ActionEXCEL_DELETE_TABLE_COLUMN

Delete Table Column

Delete a column from a table using Microsoft Graph API.

5 input
ActionEXCEL_DELETE_TABLE_ROW

Delete Table Row

Delete a row from a table using Microsoft Graph API.

5 input
ActionEXCEL_DELETE_WORKSHEET

Delete Worksheet

Tool to delete a worksheet from the workbook.

4 input
ActionEXCEL_EXPORT_WORKBOOK_TO_PDF

Export Workbook to PDF

Tool to export an Excel workbook to PDF via Microsoft Graph's format conversion.

5 input
ActionEXCEL_GET_CHART_AXIS

Get Chart Axis

Tool to retrieve a specific axis from a chart.

8 input
ActionEXCEL_GET_CHART_DATA_LABELS

Get Chart Data Labels

Tool to retrieve the data labels object of a chart.

5 input
ActionEXCEL_GET_CHART_LEGEND

Get Chart Legend

Tool to retrieve the legend object of a chart.

7 input
ActionEXCEL_GET_RANGE

Get Range

Get a range from a worksheet using Microsoft Graph API.

5 input
ActionEXCEL_GET_SHAREPOINT_RANGE

Get SharePoint Range

Get a range from a worksheet in SharePoint using Microsoft Graph Sites API.

5 input
ActionEXCEL_GET_SHAREPOINT_WORKSHEET

Get SharePoint Worksheet

Get a worksheet by name or ID from a SharePoint Excel workbook using Microsoft Graph Sites API.

4 input
ActionEXCEL_GET_WORKSHEET

Get Worksheet

Get a worksheet by name or ID from an Excel workbook using Microsoft Graph API.

4 input
ActionEXCEL_GET_WORKSHEET_USED_RANGE

Get Worksheet Used Range

Tool to retrieve a worksheet's used range (active data region) without specifying a fixed range address.

5 input
ActionEXCEL_GET_TABLE_COLUMN

Get table column

Tool to retrieve a specific column from a workbook table.

6 input
ActionEXCEL_GET_WORKBOOK

Get workbook

Tool to retrieve the properties and relationships of a workbook.

4 input
ActionEXCEL_INSERT_RANGE

Insert Range

Tool to insert a new cell range into a worksheet, shifting existing cells down or right.

6 input
ActionEXCEL_LIST_CHART_SERIES

List Chart Series

Tool to list all data series in a chart.

5 input
ActionEXCEL_LIST_CHARTS

List Charts

List charts in a worksheet using Microsoft Graph API.

4 input
ActionEXCEL_LIST_COMMENTS

List Comments

Tool to list comments in an Excel workbook.

3 input
ActionEXCEL_LIST_FILES

List Drive Files

List files and folders in a drive root or specified path.

4 input
ActionEXCEL_LIST_DRIVE_ITEM_CHILDREN

List Drive Item Children

Tool to list immediate children (files/folders) of a folder DriveItem using driveId and itemId.

4 input
ActionEXCEL_LIST_NAMED_ITEMS

List Named Items

List named items in a workbook using Microsoft Graph API.

3 input
ActionEXCEL_LIST_SHAREPOINT_TABLES

List SharePoint Tables

List tables in a SharePoint worksheet using Microsoft Graph Sites API.

4 input
ActionEXCEL_LIST_SHAREPOINT_WORKSHEETS

List SharePoint Worksheets

List worksheets in an Excel workbook stored in SharePoint using Microsoft Graph Sites API.

4 input
ActionEXCEL_LIST_TABLE_COLUMNS

List Table Columns

List columns in a table using Microsoft Graph API.

4 input
ActionEXCEL_LIST_TABLE_ROWS

List Table Rows

List rows in a table using Microsoft Graph API.

6 input
ActionEXCEL_LIST_TABLES

List Tables

List tables in a worksheet using Microsoft Graph API.

4 input
ActionEXCEL_LIST_WORKBOOK_PERMISSIONS

List Workbook Permissions

Tool to list permissions set on the workbook file.

7 input
ActionEXCEL_LIST_WORKSHEETS

List Worksheets

List worksheets in an Excel workbook using Microsoft Graph API.

3 input
ActionEXCEL_MERGE_CELLS

Merge Cells

Merge cells in a worksheet range using Microsoft Graph API.

6 input
ActionEXCEL_PROTECT_WORKSHEET

Protect Worksheet

Tool to protect a worksheet using optional protection options.

5 input
ActionEXCEL_SEARCH_FILES

Search Drive Files

Tool to search OneDrive drive items by query to discover Excel workbook IDs.

6 input
ActionEXCEL_SORT_RANGE

Sort Range

Sort a range in a worksheet using Microsoft Graph API.

7 input
ActionEXCEL_UPDATE_CHART

Update Chart

Update a chart in a worksheet using Microsoft Graph API.

10 input
ActionEXCEL_UPDATE_CHART_LEGEND

Update Chart Legend

Tool to update formatting or position of a chart legend.

8 input
ActionEXCEL_UPDATE_RANGE

Update Range

Update a range in a worksheet using Microsoft Graph API.

6 input
ActionEXCEL_UPDATE_SHAREPOINT_RANGE

Update SharePoint Range

Update a range in a SharePoint worksheet using Microsoft Graph Sites API.

6 input
ActionEXCEL_UPDATE_TABLE

Update Table

Update a table in a workbook using Microsoft Graph API.

8 input
ActionEXCEL_UPDATE_WORKSHEET

Update Worksheet

Update worksheet properties (name, position) in an Excel workbook using Microsoft Graph API.

7 input
ActionEXCEL_UPLOAD_WORKBOOK

Upload Workbook from URL

Tool to upload an external Excel file from a URL into OneDrive/SharePoint.

4 input