Files.ReadWrite.
Note: Using the delegated (OAuth) connection type will only allow to insert the connected user’s ID.
External DocumentationTo learn more, visit the Microsoft Excel documentation.
Basic Parameters
| Parameter | Description |
|---|---|
| Address | The range of cells to modify using Excel notation. For example: A1:C10 for cells A1 through C10. |
| Column Hidden | Select to hide all columns in the specified range from view. |
| Drive ID | The unique identifier of the drive (OneDrive or SharePoint document library) that contains your Excel file. |
| Formulas | Excel formulas in standard A1 notation to be inserted. Format: A JSON 2D matrix of rows and columns (inner array represents a row). For example: [["=SUM(A1:A10)", "=B1*2"]] |
| Formulas Local | Excel formulas using the user’s regional language and number formatting to be inserted. Format: A JSON 2D matrix of rows and columns (inner array represents a row). For example - German users would use SUMME instead of SUM. |
| Formulas R1C1 | Excel formulas in R1C1 reference style to be inserted. Format: A JSON 2D matrix of rows and columns (inner array represents a row). For example: [["=SUM(R1C1:R10C1)"]] |
| Item ID | The ID of the Excel file to interact with. |
| Number Format | Excel number format codes for each cell to be inserted. Format: A JSON 2D matrix of rows and columns (inner array represents a row). For example: [["0.00", "#,##0"]] for decimal and thousand separator formatting. |
| Row Hidden | Select to hide all rows in the specified range from view. |
| Site ID | The ID of the SharePoint site containing your Excel file. |
| Source | Choose whether to pull your Excel file from SharePoint or OneDrive. |
| User ID | The User ID of the user whose OneDrive contains the Excel file. Note: Using the delegated (OAuth) connection type will only allow to insert the connected user’s ID. |
| Values | The data to insert into cells. Format: A JSON 2D matrix of rows and columns (inner array represents a row). For example: [["Row1Col1", "Row1Col2"], ["Row2Col1", "Row2Col2"]] |
| Worksheet ID Or Name | The ID or display name of the worksheet to interact with. |
Advanced Parameters
| Parameter | Description |
|---|---|
| Workbook Session ID | The session ID for maintaining context across multiple operations. Using a session improves performance and allows you to control whether changes are saved. If not provided, each operation runs independently which is less efficient. For more information about the Workbook Session ID, refer to Microsoft’s documentation. |
Example Output
{
"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
"@odata.id": "/drives('abc')/items('abc')/workbook/worksheets(123)/range(address=%27B6:C7%27)/insert()",
"address": "Sheet3!B3:C4",
"addressLocal": "Sheet3!B3:C4",
"columnCount": 2,
"cellCount": 4,
"columnHidden": false,
"rowHidden": false,
"numberFormat": [
[
"General",
"General"
],
[
"m/d/yyyy",
"General"
]
],
"columnIndex": 1,
"text": [
[
"Hello",
"100"
],
[
"1/1/2016",
""
]
],
"formulas": [
[
"Hello",
100
],
[
42370,
""
]
],
"formulasLocal": [
[
"Hello",
100
],
[
42370,
""
]
],
"formulasR1C1": [
[
"Hello",
100
],
[
42370,
""
]
],
"hidden": false,
"rowCount": 2,
"rowIndex": 2,
"valueTypes": [
[
"String",
"Double"
],
[
"Double",
"Empty"
]
],
"values": [
[
"Hello",
100
],
[
42370,
""
]
]
}
Workflow Library Example
Update Range Cells with Microsoft Excel and Send Results Via Email