Get Range

External DocumentationTo learn more, visit the Microsoft Excel documentation.

Basic Parameters

Parameter	Description
Address	The cell range to retrieve using Excel notation. For example: `A1:C10` for cells A1 through C10.
Drive ID	The unique identifier of the drive (OneDrive or SharePoint document library) that contains your Excel file.
Filter	Optional filter string. Visit Microsoft’s documentation for more information.
Item ID	The ID of the Excel file to interact with.
Limit	Sets the page size of results.
Offset	The pagination offset indicating the starting point for the next set of results.
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.
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: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
		]
	]
}

Integrations

Basic Parameters

Advanced Parameters

Example Output

Workflow Library Example

​Basic Parameters

​Advanced Parameters

​Example Output

​Workflow Library Example

Basic Parameters

Advanced Parameters

Example Output

Workflow Library Example