You can wire the Excel node into an AI agent as a tool provider: the agent calls the operations you allow. See Agent tools.
Credentials
Connect Excel under Credentials in the node settings. See Connecting credentials for the general flow. Sign in with your Excel account when prompted; no keys to copy. NoClick requests the following permissions:https://graph.microsoft.com/Files.ReadWrite.Allhttps://graph.microsoft.com/User.Read
Operations
Chart
| Operation | ID | Description |
|---|---|---|
| Create Chart | create_chart | Create a new chart from data range |
| Delete Chart | delete_chart | Delete a chart from worksheet |
| Get Chart | get_chart | Get chart details by name |
| Get Chart Image | get_chart_image | Get chart as base64-encoded PNG image |
| List Worksheet Charts | list_worksheet_charts | List all charts in a worksheet |
| Update Chart | update_chart | Update chart properties (title, size, position) |
Filter
| Operation | ID | Description |
|---|---|---|
| Apply Table Column Filter | apply_table_column_filter | Apply auto-filter to a table column |
| Clear Table Column Filter | clear_table_column_filter | Clear filter from a table column |
Named item
| Operation | ID | Description |
|---|---|---|
| Create Named Item | create_named_item | Create a named range or constant |
| Get Named Item | get_named_item | Get value of a named range or item |
| List Named Items | list_named_items | List all named ranges and items in the workbook |
Range
| Operation | ID | Description |
|---|---|---|
| Clear Range Contents | clear_range_contents | Clear content, format, or both from a range |
| Delete Range and Shift Cells | delete_range_and_shift_cells | Delete cells and shift remaining cells up or left |
| Format Range | format_range | Apply formatting to a range (font, fill, borders, alignment) |
| Get Range Values | get_range_values | Get data from a specific cell range |
| Insert Blank Cells in Range | insert_blank_cells_in_range | Insert blank cells and shift existing cells down or right |
| Merge Range Cells | merge_range_cells | Merge cells into a single region |
| Sort Range by Column | sort_range_by_column | Sort a range by column |
| Unmerge Range Cells | unmerge_range_cells | Unmerge merged cells |
| Update Range Values | update_range_values | Update cell values, formulas, or formatting in a range |
Session
| Operation | ID | Description |
|---|---|---|
| Close Workbook Session | close_workbook_session | Close a workbook session |
| Create Workbook Session | create_workbook_session | Create a workbook session for persistent or non-persistent changes |
| Refresh Workbook Session | refresh_workbook_session | Refresh a workbook session to keep it alive |
Table
| Operation | ID | Description |
|---|---|---|
| Add Table Column | add_table_column | Add a column to a table |
| Add Table Row | add_table_row | Add a row to a table |
| Convert Table to Range | convert_table_to_range | Convert table to normal range (keeps data, removes table structure) |
| Create Table from Range | create_table_from_range | Create a new table from a range |
| Delete Table | delete_table | Delete a table (converts back to range) |
| Delete Table Column | delete_table_column | Delete a column from a table |
| Delete Table Row | delete_table_row | Delete a row from a table by index |
| Get Table | get_table | Get table details by name |
| List Table Columns | list_table_columns | List all columns in a table |
| List Table Rows | list_table_rows | List all rows in a table |
| List Workbook Tables | list_workbook_tables | List all tables in the workbook |
| Sort Table by Column | sort_table_by_column | Sort a table by column |
Workbook
| Operation | ID | Description |
|---|---|---|
| Execute Excel Function | execute_excel_function | Execute built-in Excel function (300+ functions available) |
| Recalculate Workbook | recalculate_workbook | Recalculate all formulas in the workbook |
Worksheet
| Operation | ID | Description |
|---|---|---|
| Add Worksheet | add_worksheet | Add a new worksheet to the workbook |
| Delete Worksheet | delete_worksheet | Delete a worksheet from the workbook |
| Get Worksheet | get_worksheet | Get worksheet details by name |
| Get Worksheet Used Range | get_worksheet_used_range | Get the used range of a worksheet (all cells with data) |
| List Workbook Worksheets | list_workbook_worksheets | List all worksheets in a workbook |
| Update Worksheet | update_worksheet | Update worksheet properties (name, visibility, position) |