Get the data and properties of a specified range of cells in a worksheet.

Least privileged Microsoft Graph permissions to access the action via delegated or application: Files.ReadWrite.

Note: Using the delegated (OAuth) connection type will only allow to insert the connected user’s ID.

External Documentation

To learn more, visit the Microsoft Excel documentation.

​
Basic Parameters

ParameterDescription
AddressThe cell range to retrieve using Excel notation.

For example: A1:C10 for cells A1 through C10.
Drive IDThe unique identifier of the drive (OneDrive or SharePoint document library) that contains your Excel file.
FilterOptional filter string. Visit Microsoft’s documentation for more information.
Item IDThe ID of the Excel file to interact with.
LimitSets the page size of results.
OffsetThe pagination offset indicating the starting point for the next set of results.
Site IDThe ID of the SharePoint site containing your Excel file.
SourceChoose whether to pull your Excel file from SharePoint or OneDrive.
User IDThe 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.
Worksheet ID Or NameThe ID or display name of the worksheet to interact with.

​
Advanced Parameters

ParameterDescription
Workbook Session IDThe 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:B4",
	"addressLocal": "Sheet3!B3:B4",
	"columnCount": 1,
	"cellCount": 2,
	"columnHidden": false,
	"rowHidden": false,
	"numberFormat": [
		[
			"General"
		],
		[
			"m/d/yyyy"
		]
	],
	"columnIndex": 1,
	"text": [
		[
			"Hello"
		],
		[
			"1/1/2016"
		]
	],
	"formulas": [
		[
			"Hello"
		],
		[
			42370
		]
	],
	"formulasLocal": [
		[
			"Hello"
		],
		[
			42370
		]
	],
	"formulasR1C1": [
		[
			"Hello"
		],
		[
			42370
		]
	],
	"hidden": false,
	"rowCount": 2,
	"rowIndex": 2,
	"valueTypes": [
		[
			"String"
		],
		[
			"Double"
		]
	],
	"values": [
		[
			"Hello"
		],
		[
			42370
		]
	]
}

​
Workflow Library Example

Get Range with Microsoft Excel and Send Results Via Email

Preview this Workflow on desktop