Actions
Delete Range Cells
Remove the specified cells from the worksheet and shift remaining cells to fill the gap.
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
| Parameter | Description |
|---|---|
| Address | The range of cells to delete 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. |
| Item ID | The ID of the Excel file to interact with. |
| Shift | Specify the direction to move remaining 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. 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. |
Workflow Library Example
Delete Range Cells with Microsoft Excel and Send Results Via Email
Preview this Workflow on desktop