Integrations
Microsoft Excel
9 actions for Microsoft Excel.
Apply Excel Formula#
Apply a formula to a cell or range in an Excel worksheet.
Plans: Trial, Pro, Premium, Enterprise · Type: ExcelApplyFormula
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workbook ID | Text | Yes | (empty) | The ID of the Excel workbook. |
| Worksheet Name | Text | Yes | (empty) | The name of the worksheet. |
| Range Address | Text | Yes | (empty) | The range address (e.g., ‘A1’ or ‘A1:A10’). |
| Formula | Text | Yes | (empty) | The Excel formula to apply (e.g., ‘=SUM(B1:B10)’). |
Outputs#
| Output | Type |
|---|---|
| Success | Yes/No |
| Range Address | Text |
| Formula | Text |
Use as an agent tool#
Tool name: excel_apply_formula
Apply a formula to a cell or range in an Excel worksheet
Create Excel Chart#
Create a new chart in an Excel worksheet.
Plans: Trial, Pro, Premium, Enterprise · Type: ExcelCreateChart
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workbook ID | Text | Yes | (empty) | The ID of the Excel workbook. |
| Worksheet Name | Text | Yes | (empty) | The name of the worksheet. |
| Chart Type | Text | No | ColumnClustered | Type of chart to create. Options: ColumnClustered, ColumnStacked, ColumnStacked100, Line, LineStacked, LineStacked100, LineMarkers, Pie, PieOfPie, BarClustered, BarStacked, BarStacked100 and 6 more |
| Source Data Range | Text | Yes | (empty) | Range of source data for the chart (e.g., ‘A1:B10’). |
| Chart Name | Text | No | New Chart | Name for the chart. |
Outputs#
| Output | Type |
|---|---|
| Success | Yes/No |
| Name | Text |
| Chart Type | Text |
| Source Data | Text |
Use as an agent tool#
Tool name: excel_create_chart
Create a new chart in an Excel worksheet
Create Excel Worksheet#
Create a new worksheet in an Excel workbook.
Plans: Trial, Pro, Premium, Enterprise · Type: ExcelCreateWorksheet
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workbook ID | Text | Yes | (empty) | The ID of the Excel workbook. |
| Worksheet Name | Text | Yes | (empty) | The name for the new worksheet. |
Outputs#
| Output | Type |
|---|---|
| Worksheet Id | Text |
| Name | Text |
| Position | Any |
| Visibility | Any |
Use as an agent tool#
Tool name: excel_create_worksheet
Create a new worksheet in an Excel workbook
Delete Excel Worksheet#
Delete a worksheet from an Excel workbook.
Plans: Trial, Pro, Premium, Enterprise · Type: ExcelDeleteWorksheet
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workbook ID | Text | Yes | (empty) | The ID of the Excel workbook. |
| Worksheet ID | Text | Yes | (empty) | The ID of the worksheet to delete. |
Outputs#
| Output | Type |
|---|---|
| Success | Yes/No |
| Worksheet Id | Text |
Use as an agent tool#
Tool name: excel_delete_worksheet
Delete a worksheet from an Excel workbook
Get Excel Charts#
Get charts from an Excel worksheet.
Plans: Trial, Pro, Premium, Enterprise · Type: ExcelGetCharts
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workbook ID | Text | Yes | (empty) | The ID of the Excel workbook. |
| Worksheet Name | Text | Yes | (empty) | The name of the worksheet. |
| Chart Name | Text | No | (empty) | Optional specific chart name to filter. |
Outputs#
| Output | Type |
|---|---|
| Charts | List |
| Charts Count | Number |
Use as an agent tool#
Tool name: excel_get_charts
Get charts from an Excel worksheet
Get Excel Range#
Get data from a specific range in an Excel worksheet.
Plans: Trial, Pro, Premium, Enterprise · Type: ExcelGetRange
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workbook ID | Text | Yes | (empty) | The ID of the Excel workbook. |
| Worksheet Name | Text | Yes | (empty) | The name of the worksheet. |
| Range Address | Text | Yes | (empty) | The range address (e.g., ‘A1:C10’). |
Outputs#
| Output | Type |
|---|---|
| Range Address | Text |
| Row Count | Number |
| Column Count | Number |
| Values | Any |
| Formulas | Any |
Use as an agent tool#
Tool name: excel_get_range
Get data from a specific range in an Excel worksheet
Get Excel Worksheets#
Get worksheets from an Excel workbook.
Plans: Trial, Pro, Premium, Enterprise · Type: ExcelGetWorksheets
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workbook ID | Text | Yes | (empty) | The ID of the Excel workbook. |
Outputs#
| Output | Type |
|---|---|
| Worksheets | List |
| Worksheets Count | Number |
Use as an agent tool#
Tool name: excel_get_worksheets
Get worksheets from an Excel workbook
List Excel Workbooks#
List Excel workbooks from OneDrive.
Plans: Trial, Pro, Premium, Enterprise · Type: ExcelListWorkbooks
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Folder Path | Text | No | (empty) | Optional folder path in OneDrive to search for workbooks. |
| Max Results | Number | No | 50 | Maximum number of workbooks to return. |
Outputs#
| Output | Type |
|---|---|
| Workbooks | List |
| Workbooks Count | Number |
Use as an agent tool#
Tool name: excel_list_workbooks
List Excel workbooks from OneDrive
Update Excel Range#
Update data in a specific range in an Excel worksheet.
Plans: Trial, Pro, Premium, Enterprise · Type: ExcelUpdateRange
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workbook ID | Text | Yes | (empty) | The ID of the Excel workbook. |
| Worksheet Name | Text | Yes | (empty) | The name of the worksheet. |
| Range Address | Text | Yes | (empty) | The range address (e.g., ‘A1:C10’). |
| Values | List | Yes | — | 2D array of values to update (e.g., [[1, 2], [3, 4]]). |
Outputs#
| Output | Type |
|---|---|
| Success | Yes/No |
| Range Address | Text |
| Cells Updated | Number |
Use as an agent tool#
Tool name: excel_update_range
Update data in a specific range in an Excel worksheet