Microsoft Excel logo

Microsoft Excel

Connect Microsoft Excel through Nango.

27 agent tools Integration catalog
Request access
Connect Microsoft Excel and choose your agent’s tools.
01 · WHAT THE AGENT CAN DO

Agent tools

Each tool is an action the agent calls by name, scoped to what you authorize and recorded in the run trace.

add chartMICROSOFT_EXCEL_ADD_CHART
Create a chart on a worksheet from a data range.
add defined nameMICROSOFT_EXCEL_ADD_DEFINED_NAME
Create a workbook-level defined name (named range or formula).
add table rowsMICROSOFT_EXCEL_ADD_TABLE_ROWS
Append one or more rows to a table.
add tableMICROSOFT_EXCEL_ADD_TABLE
Create a table from an existing range.
add worksheetMICROSOFT_EXCEL_ADD_WORKSHEET
Add a new worksheet to a workbook.
calculate workbookMICROSOFT_EXCEL_CALCULATE_WORKBOOK
Force recalculation of all formulas in the workbook.
create workbookMICROSOFT_EXCEL_CREATE_WORKBOOK
Upload a new .xlsx workbook to a drive folder.
delete defined nameMICROSOFT_EXCEL_DELETE_DEFINED_NAME
Delete a workbook-level defined name.
delete tableMICROSOFT_EXCEL_DELETE_TABLE
Delete a table (converts it back to a normal range; does not delete the underlying cell data).
delete workbookMICROSOFT_EXCEL_DELETE_WORKBOOK
Delete a workbook file.
delete worksheetMICROSOFT_EXCEL_DELETE_WORKSHEET
Delete a worksheet from a workbook.
get chart imageMICROSOFT_EXCEL_GET_CHART_IMAGE
Render a chart as an image.
get rangeMICROSOFT_EXCEL_GET_RANGE
Read cell values from a specific range on a worksheet.
get site driveMICROSOFT_EXCEL_GET_SITE_DRIVE
Get the default document library (drive) for a SharePoint site.
get used rangeMICROSOFT_EXCEL_GET_USED_RANGE
Read all non-empty cells on a worksheet.
get user driveMICROSOFT_EXCEL_GET_USER_DRIVE
Get a user's personal OneDrive (drive).
get workbookMICROSOFT_EXCEL_GET_WORKBOOK
Retrieve driveItem metadata for a workbook.
list defined namesMICROSOFT_EXCEL_LIST_DEFINED_NAMES
List workbook-level defined names.
list sitesMICROSOFT_EXCEL_LIST_SITES
Search and list SharePoint sites accessible to the app.
list table columnsMICROSOFT_EXCEL_LIST_TABLE_COLUMNS
List the columns of a table
list table rowsMICROSOFT_EXCEL_LIST_TABLE_ROWS
List the data rows of a table.
list tablesMICROSOFT_EXCEL_LIST_TABLES
List tables in a workbook.
list usersMICROSOFT_EXCEL_LIST_USERS
List/search tenant users, to resolve a user id for personal OneDrive access.
list workbooksMICROSOFT_EXCEL_LIST_WORKBOOKS
List and search .xlsx files within a drive.
list worksheetsMICROSOFT_EXCEL_LIST_WORKSHEETS
List worksheets in a workbook.
update rangeMICROSOFT_EXCEL_UPDATE_RANGE
Write cell values into a specific range on a worksheet
update worksheetMICROSOFT_EXCEL_UPDATE_WORKSHEET
Rename a worksheet and/or change its tab position.