Microsoft Excel
Read, write, and update data
Configuration
Read Data
Operation
Read Data
Microsoft Account*
Select Microsoft account
Select Sheet
Select a spreadsheet
Spreadsheet ID
Enter spreadsheet ID
Range
Sheet name and cell range (e.g., Sheet1!A1:D10)
Read Data (
microsoft_excel_read)Read data from a Microsoft Excel spreadsheet
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The ID of the spreadsheet to read from |
range | string | No | The range of cells to read from. Accepts "SheetName!A1:B2" for explicit ranges or just "SheetName" to read the used range of that sheet. If omitted, reads the used range of the first sheet. |
Output
| Parameter | Type | Description |
|---|---|---|
range | string | The range that was read |
Write/Update Data
Operation
Write/Update Data
Microsoft Account*
Select Microsoft account
Select Sheet
Select a spreadsheet
Spreadsheet ID
Enter spreadsheet ID
Range
Sheet name and cell range (e.g., Sheet1!A1:D10)
Values*
Enter values as JSON array of arrays (e.g., [["A1", "B1"], ["A2", "B2"]]) or an array of objects (e.g., [{"name":"John", "age":30}, {"name":"Jane", "age":25}])
Value Input Option
Select...
Write/Update Data (
microsoft_excel_write)Write data to a Microsoft Excel spreadsheet
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The ID of the spreadsheet to write to |
range | string | No | The range of cells to write to |
values | array | Yes | The data to write to the spreadsheet |
valueInputOption | string | No | The format of the data to write |
includeValuesInResponse | boolean | No | Whether to include the written values in the response |
Output
| Parameter | Type | Description |
|---|---|---|
updatedRange | string | The range that was updated |
updatedRows | number | Number of rows that were updated |
updatedColumns | number | Number of columns that were updated |
updatedCells | number | Number of cells that were updated |
spreadsheetId | string | The ID of the spreadsheet |
Add to Table
Operation
Add to Table
Microsoft Account*
Select Microsoft account
Select Sheet
Select a spreadsheet
Spreadsheet ID
Enter spreadsheet ID
Table Name*
Name of the Excel table
Values*
Enter values as JSON array of arrays (e.g., [["A1", "B1"], ["A2", "B2"]]) or an array of objects (e.g., [{"name":"John", "age":30}, {"name":"Jane", "age":25}])
Add to Table (
microsoft_excel_table_add)Add new rows to a Microsoft Excel table
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The ID of the spreadsheet containing the table |
tableName | string | Yes | The name of the table to add rows to |
values | array | Yes | The data to add to the table (array of arrays or array of objects) |
Output
| Parameter | Type | Description |
|---|---|---|
index | number | Index of the first row that was added |
values | array | Array of rows that were added to the table |
spreadsheetId | string | The ID of the spreadsheet |
Usage Instructions
Integrate Microsoft Excel into the workflow. Can read, write, update, and add to table.
Notes
- Category:
tools - Type:
microsoft_excel