> ## 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.

# Get Worksheet

Get detailed information about a specific worksheet.

**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/worksheet-get?view=graph-rest-1.0\&tabs=http).
</Note>

## Basic Parameters

<div className="integrations-table">
  | Parameter            | Description                                                                                                                                                                         |
  | -------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | 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.                                                                                                                                          |
  | 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#drives('abc')/items('abc')/workbook/worksheets/$entity",
	"@odata.id": "/drives('abc')/items('abc')/workbook/worksheets(123)/range(address=%27B6:C7%27)/insert()",
	"id": "{86138AC8-AA75-4AF7-BEC3-D0E4806A26A4}",
	"name": "Sheet2",
	"position": 1,
	"visibility": "Visible"
}
```

## Workflow Library Example

[Get Worksheet with Microsoft Excel and Send Results Via Email](https://library.blinkops.com/workflows/get-worksheet-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/get-worksheet-with-microsoft-excel-and-send-results-via-email/canvas" />
</div>