Microsoft Excel
Read and write data with sheet selection
Integrate Microsoft Excel into the workflow with explicit sheet selection. Can read and write data in specific sheets.
Read data from a specific sheet in a Microsoft Excel spreadsheet
| Parameter | Type | Required | Description |
|---|
spreadsheetId | string | Yes | The ID of the spreadsheet/workbook to read from (e.g., "01ABC123DEF456") |
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. |
| Parameter | Type | Description |
|---|
sheetName | string | Name of the sheet that was read |
range | string | The range that was read |
values | array | Array of rows containing cell values |
metadata | json | Spreadsheet metadata including ID and URL |
↳ spreadsheetId | string | Microsoft Excel spreadsheet ID |
↳ spreadsheetUrl | string | Spreadsheet URL |
Write data to a specific sheet in a Microsoft Excel spreadsheet
| Parameter | Type | Required | Description |
|---|
spreadsheetId | string | Yes | The ID of the spreadsheet/workbook to write to (e.g., "01ABC123DEF456") |
range | string | No | The range of cells to write to (e.g., "Sheet1!A1:B2") |
values | array | Yes | The data to write as a 2D array (e.g., [["Name", "Age"], ["Alice", 30]]) or array of objects |
valueInputOption | string | No | No description |
includeValuesInResponse | boolean | No | No description |
| Parameter | Type | Description |
|---|
updatedRange | string | Range of cells that were updated |
updatedRows | number | Number of rows updated |
updatedColumns | number | Number of columns updated |
updatedCells | number | Number of cells updated |
metadata | json | Spreadsheet metadata including ID and URL |
↳ spreadsheetId | string | Microsoft Excel spreadsheet ID |
↳ spreadsheetUrl | string | Spreadsheet URL |
