Read and write Microsoft Excel workbooks stored in OneDrive or SharePoint from workflows.
Authentication: OAuth 2.0. Connect your Microsoft account on the integrations page. The Excel integration accesses files stored in OneDrive or SharePoint.
Actions
Get Workbook by Name
Finds and returns an Excel workbook by its file name.
| Input | Required | Description |
|---|---|---|
| File Name | Yes | Name of the Excel file (with or without .xlsx) |
| Output | Type | Description |
|---|---|---|
workbook | object | Workbook metadata with id, name, webUrl |
Get Sheet
Returns a specific sheet within a workbook.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Workbook ID from Get Workbook |
| Sheet Name | Yes | Name of the sheet tab |
| Output | Type | Description |
|---|---|---|
sheet | object | Sheet object with id, name |
Get Workbook Summary
Returns an overview of a workbook including all its sheets and their ranges.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Workbook ID |
| Output | Type | Description |
|---|---|---|
sheets | array | Sheet objects with names and used ranges |
Add Sheet to Workbook
Adds a new sheet tab to a workbook.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Target workbook |
| Sheet Name | Yes | Name for the new sheet |
| Output | Type | Description |
|---|---|---|
sheet | object | Created sheet with id, name |
Get Tables
Returns all tables in a workbook.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Workbook ID |
| Output | Type | Description |
|---|---|---|
tables | array | Table objects with id, name, worksheetId |
Get Table Rows
Returns rows from an Excel table.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Workbook ID |
| Table ID | Yes | Table ID |
| Output | Type | Description |
|---|---|---|
rows | array | Row objects (keyed by column headers) |
rowCount | number | Number of rows returned |
Add Table Row
Inserts a new row into a table.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Workbook ID |
| Table ID | Yes | Table to add to |
| Row Data | Yes | Column → value mapping |
Delete Table Row
Deletes a row by its index.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Workbook ID |
| Table ID | Yes | Table ID |
| Row Index | Yes | Zero-based row index |
Update Cells
Sets values in a cell range.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Workbook ID |
| Sheet Name | Yes | Target sheet |
| Range | Yes | A1 notation range (e.g. A1:C3) |
| Values | Yes | 2D array of values |
Insert Formulas
Writes formula strings into a cell range.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Workbook ID |
| Sheet Name | Yes | Target sheet |
| Range | Yes | A1 notation range |
| Formulas | Yes | 2D array of formula strings |
Insert / Delete Column
Inserts or removes a column in a sheet.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Workbook ID |
| Sheet Name | Yes | Target sheet |
| Column Index | Yes | Zero-based column index |
| Count | No | Number of columns to insert/delete |
Insert / Delete Row
Inserts or removes a row in a sheet.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Workbook ID |
| Sheet Name | Yes | Target sheet |
| Row Index | Yes | Zero-based row index |
| Count | No | Number of rows to insert/delete |
Clear Range
Clears the contents of a cell range.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Workbook ID |
| Sheet Name | Yes | Target sheet |
| Range | Yes | A1 notation range to clear |
Format Cells
Applies number formatting to a cell range.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Workbook ID |
| Sheet Name | Yes | Target sheet |
| Range | Yes | Target range |
| Format | Yes | Excel number format string (e.g. 0.00, dd/mm/yyyy) |
Sort Range
Sorts a cell range by a column.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Workbook ID |
| Sheet Name | Yes | Target sheet |
| Range | Yes | Range to sort |
| Column Index | Yes | Zero-based column to sort by |
| Ascending | No | Sort direction (default: true) |
Create Chart
Creates a chart in a workbook sheet.
| Input | Required | Description |
|---|---|---|
| Workbook ID | Yes | Workbook ID |
| Sheet Name | Yes | Target sheet |
| Chart Type | Yes | Chart type (e.g. ColumnClustered, LineMarkers) |
| Data Range | Yes | A1 notation data range for the chart |
| Title | No | Chart title |