> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blinkops.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Insert Range Cells

Add new empty cells at the specified location, automatically shifting existing cells to make room.

**Least privileged** Microsoft Graph permissions to access the action via **application**: `Files.ReadWrite`.

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

<Note>
  External Documentation

  To learn more, visit the [Microsoft Excel documentation](https://learn.microsoft.com/en-us/graph/api/range-insert?view=graph-rest-1.0\&tabs=http).
</Note>

## Basic Parameters

<div className="integrations-table">
  | Parameter            | Description                                                                                                                                                                         |
  | -------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | Address              | The location where new cells should be inserted using Excel notation.<br /><br />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.                                                                         |
  | Item ID              | The ID of the Excel file to interact with.                                                                                                                                          |
  | Shift                | The direction to move existing cells.                                                                                                                                               |
  | 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.<br /><br />**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.                                                                                                                           |
</div>

## Advanced Parameters

<div className="integrations-table">
  | 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.<br /><br />For more information about the `Workbook Session ID`, refer to [Microsoft's documentation](https://learn.microsoft.com/en-us/graph/api/workbook-createsession?view=graph-rest-1.0\&tabs=http). |
</div>

## Example Output

```json theme={"dark"}
{
	"@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!B6:C7",
	"addressLocal": "Sheet3!B6:C7",
	"columnCount": 2,
	"cellCount": 4,
	"columnHidden": false,
	"rowHidden": false,
	"numberFormat": [
		[
			"General",
			"General"
		],
		[
			"General",
			"General"
		]
	],
	"columnIndex": 1,
	"text": [
		[
			"",
			""
		],
		[
			"",
			""
		]
	],
	"formulas": [
		[
			"",
			""
		],
		[
			"",
			""
		]
	],
	"formulasLocal": [
		[
			"",
			""
		],
		[
			"",
			""
		]
	],
	"formulasR1C1": [
		[
			"",
			""
		],
		[
			"",
			""
		]
	],
	"hidden": false,
	"rowCount": 2,
	"rowIndex": 5,
	"valueTypes": [
		[
			"Empty",
			"Empty"
		],
		[
			"Empty",
			"Empty"
		]
	],
	"values": [
		[
			"",
			""
		],
		[
			"",
			""
		]
	]
}
```

## Workflow Library Example

[Insert Range Cells with Microsoft Excel and Send Results Via Email](https://library.blinkops.com/workflows/insert-range-cells-with-microsoft-excel-and-send-results-via-email)

<div className="iframe-wrapper">
  <div className="iframe-media">
    <img src="https://mintcdn.com/blinkops-2/ojHYuDeYX5FWuN8a/img/Icons/play-box.svg?fit=max&auto=format&n=ojHYuDeYX5FWuN8a&q=85&s=b8af968e71438a9499c3223c9bd29fb2" alt="Workflow Library" width="16" height="16" data-path="img/Icons/play-box.svg" />

    Preview this Workflow on desktop
  </div>

  <iframe className="iframe" src="https://library.blinkops.com/workflows/insert-range-cells-with-microsoft-excel-and-send-results-via-email/canvas" />
</div>